Sorting Columns By month

  • Thread starter Thread starter Branden
  • Start date Start date
B

Branden

Is there a way to sort a column by the month and exclude
the year. So if you had 1/15/03 and 1/15/2004 it would be
grouped by the month.
 
Hi
one way: Use a helpercolumn: If your dates are stored in column A enter
the following in column B, cell B1
=MONTH(A1)
copy this down for all your data rows
Use this helper column as sorting criteria
 
You also need to determine what to do if there could be data for the same
month in differing years, so your formula might be better as

=YEAR(A1)&FORMAT(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