How do I sort a column of dates by the month?

S

Shannon

I have the column formatted by date like: 8/30/06

Any way I sort, it only sorts by the year. How can I sort the column by the
month??

Thanks!!
 
T

T Kirtley

You could add a column with just the month using a formula like: =MONTH(A1)
which will show the month of the date in cell A1. Then you can sort by this
column.

HTH,
TK
 
D

Dave F

run a helper column down next to the date column using the MONTH function and
sort on that helper column.

Example: A1 = 8/1/06. B1 =MONTH(A1) which returns 8. Copy down as needed.
Sort.

Dave
 
D

Dave O

1. Insert a "helper" column next to the dates.
2. In this new column, enter the formula =MONTH(a1) where A1 is the
first of the dates you want to sort
3. Copy that formula and paste into all relevant rows
4. Sort on that new column
5. Delete the new column.

Vwalla!
 
Top