Sort date by day and not year

[Kathy]

Need to sort birthdates by month and day; ignore year.

Ex:
Would like to sort like list below:
3/02/1997
3/15/2002
3/21/1996

Not like this:
3/21/1996
3/02/1997
3/15/2002

Please help and thank you for your help.
Kathy

 

[Frank Kabel]

Hi
one way:
- add an additional helper column (lets ay B)
- insert the following formula in B1 (if column A stores your list):
=MONTH(A1)
- copy this formula for all rows
- sort with this helper column

 

[Niek Otten]

Use a "helper' Column, with the formula

=TEXT(MONTH(A1),"00")&TEXT(DAY(A1),"00")

And sort both columns with the new one as key

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel