How do I sort a column of dates by the month?
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
"Shannon" wrote:
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!!
|