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.