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)

"kauflton" wrote in message
...
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