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

G

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.
 
R

Ron de Bruin

Hi ejeff

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

and sort on this columns
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I sort a list of dates in Excel by month and day? 3
Sort by date but not year 4
Sort Dates 11
Sorting date fields by month excluding year 1
How do I sort by month and day 5
How do I list dates without years? 1
Excel 2003 How do I determine an age of "?" using a set date as r 1
Birthdate Months 4

Top