View Single Post
  #3   Report Post  
Niek Otten
 
Posts: n/a
Default

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