Excel Problem

  • Thread starter Thread starter Tena Ward
  • Start date Start date
T

Tena Ward

I have a column formatted as date--February 12, 2004.
These are birthdays of students born over a six year
period. I would like to sort the sheet by month of birth
instead of by date of birth. To do this, I would have to
convince Excel that February 12, 2004 is text. Any
suggestions?
 
Add a helper column, and sort on this. In the first row of this column, add
the formula

=MONTH(A1)

and copy down.

If you want to include the year, put

=TEXT(YEAR(A1)) & TEXT(MONTH(A1),"00")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top