If the Excel Date Filter is not grouping by month, enable grouping dates in the AutoFilter menu, set dates in the proper format, etc.

How to create a grouped PivotTable in Excel Grouping is what Excel’s PivotTable objects do, and it’s easy to summarize groups of data using any number of functions.