Sorting birthdays by month and day

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

I have a column of birthdates (with years) and would like to sort these in
chronological order without reference to year of birth so I can determine
the order of birthdays during the year.

ps Thanks to Arvi and Dave for previous response-perfect.

Thanks,
Craig
 
Use another column to pull out the month index and sort
ascending based on this column:

=MONTH(A1)

HTH
Jason
Atlanta, GA
 
Hi Craig,

Easiest is to introduce two extra columns with month and day, and use these
to sort all three columns
=Day(A1) and = Month(A1)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Add another column to your table.
In the first row of data, enter a formula that refers to the date, e.g.:

=TEXT(A2,"mm-dd")

where the birth date is in cell A2

Copy the formula down to the last row of data.
Sort on this column to organize the birthdays by month and day.
 

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

Sorting by month, disregarding the year 3
How do I list dates without years? 1
How do I sort by month and day 5
Sort by date but not year 4
Segment and count birthdays 2
how do I sort dates by months? 2
How do I sort a birthdate list by month then day regardless of ye. 1
Sort by date month and not year 4

Back
Top