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

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.

Hi ejeff

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

and sort on this columns

--
Regards Ron de Bruin
http://www.rondebruin.nl


"ejeff" wrote in message ...
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.