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

[Guest]

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.

 

[Ron de Bruin]

Hi ejeff

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

and sort on this columns