View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
squenson via OfficeKB.com squenson via OfficeKB.com is offline
external usenet poster
 
Posts: 78
Default How do you sort the data by the month of the data?

You should create a new column, let's say G, with the formula G2: =MONTH(A2),
where A is the column containing the date. Then you can sort according to
this column. But if you have dates for more than one year, all the entries
for January 2006 and January 2007 will be sorted together. Use instead
G2=YEAR(A2)*100+MONTH(A2) to avoid this situation.

Stephane.

--
Message posted via http://www.officekb.com