When you drop the Date field into your pivot table, i.e. Months going
down the left hand side of the table, right click and select Group &
OutlineGroup

You can then choose from the list supplied in the dialog box that
appears to set the groupings my month year days etc.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/