Grouping the Date Field by Days, Months, Quarters, and Years in Excel 2007

To Group the Date field by days, months, quarters, and years:

1. Drag the Date field to Row Labels area in PivotTable Field List dialog box (this area must contain a Date field only).
2. Select a cell in the Date field, right-click and select Group.
3. In the Grouping dialog box, select Days, Months, Quarters or Years.

CAUTION!!! If the message Cannot Group that selection appears, drag the Date field out from Row Labels, go to the source data, check the date column in the source data for empty cells or for dates that are not in a date format, fix their format, then select the PivotTable report, refresh it, drag the Date field to Row Labels again and try Group the field again.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.