How do I sort a list of dates in Excel by month and day?

G

Guest

I have a list of birthdate in excel (imported from another program). I would
like to be able to sort this list by month and day (for a "birthday list").
Any suggestions?
 
D

Dave Peterson

If the data are really dates, you could use a helper column filled with this
kind of formula:

=text(a2,"mmdd")

And sort by that.
 
G

Guest

Lets assume Names are in column A and birthdate is in column b. Put your
curser in the first cell B1. Hit Shift then space bar, you will see the
whole row selected. While still holding shift page down to the last row of
info then hit "sort Ascending" button in the toolbar. If you dont see the
button for it then hit Data>sort from the Data menu at the top.
 
D

Dave Peterson

That'll sort by date. I think Carolyn wants it so that all of January's
birthdays are together--no matter what year they're from.
 

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

Segment and count birthdays 2
Sort by date month and not year 4
Excel adding blank rows when sorting 2
Sort Dates 11
How do I sort a birthdate list by month then day regardless of ye. 1
Excel sort for month and day only 1
Sort dates Excel 2007 1
Separating dates from one column to Month, Date, Year columns 2

Top