» Pivot Table - Grouping dates by weeks in Microsoft Excel
CATEGORY - Excel Pivot Tables
VERSION - All Microsoft Excel Versions
To do so, you must locate the first Sunday or Monday of the data table and define it as a date to begin grouping the dates.
Often, the location of the first Sunday will be before the first date of the data table. For example (see screen shot), the first date of the data table is 5/10/1996. To determine if this is a Sunday:
- In any cell outside the PivotTable, enter the date 5/10/96.
- Select the cell and press Ctrl+1 (Format Cells).
- Select the Number tab.
- Select Custom. In the Type box, type dddd.
- Click OK.
- Restore the PivotTable to its original structure, in which the fields are located in the upper left of the PivotTable (Page) and are not filtered. Notice the appearance of the word All in the Field Name box. The data area includes one total row for the data.
- Drag the date field and position it in Row.
- Select one of the dates in the Date field.
- Right-click, select Group and Outline from the shortcut menu, and select Grouping.
- In the Starting at box, type 5/5/96, and leave the check box empty. Select Days.
- For the number of days, type 7.
-
Click OK.
Screenshot // Pivot Table - Grouping dates by weeks in Microsoft Excel 
Book Store:
No comments have been submitted.
