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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference Formula Help 1
Sort "mm-dd-yyyy" by year 3
pull data from one table to another if multiple conditions are met 3
Change Default Auto-Fill-In month 4
Sorting date fields by month excluding year 1
If statement with dates 0
Convert Age to Months 3
Sorting based on one column 1

Back
Top