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.