you can group by month by right-clicking on a date label, group, select
'month'.

also can you insert a column in the data with a formula like
=text([date cell],"mmmm-yy") to get a new month label to group by.
this can be useful if you have financial years that don't start on 1
Jan and need to manipulate the month number.

regards..


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=548616