Hi Craig,
Easiest is to introduce two extra columns with month and day, and use these
to sort all three columns
=Day(A1) and = Month(A1)
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"Craig" wrote in message
...
I have a column of birthdates (with years) and would like to sort these in
chronological order without reference to year of birth so I can determine
the order of birthdays during the year.
ps Thanks to Arvi and Dave for previous response-perfect.
Thanks,
Craig
|