Excel sort for month and day only

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

Guest

I have scanned a file and imported it into Excel. I want to sort by birthday
dates: Months and years , but not the year dates. I formatted the columns for
just month and day, but Excel still sorts returns results including the year!
There are hundreds of items and I do not want to have to change the year date
on each one! Please advise on what else I can do to get the sort I want.
 
Assuming the date in A1, in an adjacent column put a formula like

=MONTH(A1)*100+DAY(A1)

Then sort on that column.

PS: If you wanted to change the year, you could do it easily, again with a
formula =DATE(2004,MONTH(A1),DAY(A1))
 
Back
Top