sort dates by month and day not year
 

How can I sort by birthdays when I have birthday entered in by date of birth?
It sorts by the year first. I just need it to sort by month and day. I
have tried changing format and that will not work. I have over 5000 dates so
I don't want to change each one.

Introduce 2 helper columns. =MONTH(A1) and =DAY(A1). Use those to sort the
entire region

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"dianne" wrote in message
...
How can I sort by birthdays when I have birthday entered in by date of
birth?
It sorts by the year first. I just need it to sort by month and day. I
have tried changing format and that will not work. I have over 5000 dates
so
I don't want to change each one.

Hi

Use an additional column with formula like
=TEXT(A2,"mm.dd")
where A2 contains the date of birth.


Arvi Laanemets


"dianne" wrote in message
...
How can I sort by birthdays when I have birthday entered in by date of
birth?
It sorts by the year first. I just need it to sort by month and day. I
have tried changing format and that will not work. I have over 5000 dates
so
I don't want to change each one.