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