Excel sort for month and day only

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

Myrna Larson

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))
 

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

Sort Dates 11
Date Sorting in Excel 2003 1
Sorting date fields by month excluding year 1
Separating dates from one column to Month, Date, Year columns 2
How do I sort by month and day 5
Sorting a date by month, date and then year. 2
Sorting by month and year and ignoring the day 2
Sort by Month 1

Top