I want to sort a date field and have it put in order by months, ignoring the year. Is this possible?
K kramsey Nov 1, 2004 #1 I want to sort a date field and have it put in order by months, ignoring the year. Is this possible?
N Niek Otten Nov 1, 2004 #2 Introduce an extra column. If your dates are in A, then B1 is =MONTH(A1) Copy down as far as needed. Now sort both columns, but use B as the sortkey -- Kind Regards, Niek Otten Microsoft MVP - Excel
Introduce an extra column. If your dates are in A, then B1 is =MONTH(A1) Copy down as far as needed. Now sort both columns, but use B as the sortkey -- Kind Regards, Niek Otten Microsoft MVP - Excel
C Chip Pearson Nov 1, 2004 #3 The easiest way is to use and additional column containing a formula to return the month, and sort on that column. For example, in an empty column, enter the formula =MONTH(A1) and copy down as far as you need to go. Then, sort by this column. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
The easiest way is to use and additional column containing a formula to return the month, and sort on that column. For example, in an empty column, enter the formula =MONTH(A1) and copy down as far as you need to go. Then, sort by this column. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
