View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IanC[_2_] IanC[_2_] is offline
external usenet poster
 
Posts: 157
Default Sorting dates, ignoring year

I have a speadsheet of birthdays which I would like to change to be
birthdates. At the moment, everyone's birthdays are specified on one column
in the format dd/mm/2002 so that I can sort the worksheet to keep the dtaes
in order throughout the year.

Is there an easy way to sort a column of dates but ignore the year? Or do I
need to split the dates into multiple columns?

--
Ian
--