How to sort by birthdate

  • Thread starter Thread starter Lee Robinson
  • Start date Start date
L

Lee Robinson

I have a spreadsheet (exported from Outlook) that has the
birthdates for several contacts. The date was imported
in mm/dd/yyyy format. I have tried unsucessfully to
sort by the Month value only.

I want to get a list of contacts, sorted by their birth
month (not year), so that I can keep up with birthdays.
 
You can try making a column next to the birthday called "Birth month" and
use a formula like =MONTH(cell with birthdate).

This will return a number, which you can sort on.
 
Lee

Assuming the dates are in Column A.

In B1 enter =MONTH(A1) and drag/copy down or just double-click on the fill
handle of B1(small black lump at bottom right corner of cell)

This should return a series of numbers corresponding to the month of each
date.

If it doesn't, could be your dates are in text format.

Select Column A and Data>Text to Columns>Next>Next "column
format">date>MDY>Finish.

Gord Dibben Excel MVP
 
I'd use a helper column and put a formula like:

=text(a2,"mmdd")

Then I'd could sort by month (and by date within month).
 
Back
Top