Pivot tables can group dates by year, month, and quarter.

In the example shown, there are 100 names and birthdays in the source data.

A pivot table is used to count the birthdays that occur in each month of the year.

Field list for birthdays per month pivot table

Fields

The source data contains two fields:Name, andBirthdate.

Then add the Month field to the pivot table directly.

Steps

Notes

Field list for birthdays per month pivot table

Field list for birthdays per month pivot table

Field list for birthdays per month pivot table

Field list for birthdays per month pivot table

Birthdates are grouped by Months only

Name is summarized by count by default