sorting dates by month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sheet with a column of dates in the standard format mm/dd/yy
A simple A to Z sort - sorts on the year. Could anyone tell me how to sort it by the month instead
Thankyou
 
Hi Kauflton!

Add a helper column with the following as the basis formula:

=TEXT(A1,"mmddyyyy")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi

I would add a helper column. Insert the following in the first row
=MONTH(A1)
copy this down for all rows and then sort by this helper column

HTH
Frank
 
You need a helper column with a formula, such as

=MONTH(A1)

and sort both columns with the helper column as the key.

If you wish to include year, you could try

=TEXT(A1,"yyyymm")

--

HTH

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