sort dates by month and day not year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi

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


Arvi Laanemets
 
Back
Top