How do I sort a birthdate list by month then day regardless of ye.

E

ejeff

I created a spreadsheet with customer data which includes their birthdate.
How should it be entered so that I can sort it according to month then day
regardless of year? I just want to see a list of birthdays coming up.
 
R

Ron de Bruin

Hi ejeff

You can use helper columns
=month(a1)
=day(a1)

and sort on this columns
 
Top