Date grouping in a PivotTable aggregates dates by month, quarter or year, or by several levels at once. It turns a column of detailed dates into readable periods for tracking a trend. It requires date-type values, with no text or empty cell in the column.
Example
Group the Date column by Years and Months to get a total per month.