View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T Kirtley T Kirtley is offline
external usenet poster
 
Posts: 82
Default 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!!