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

Learn to use Excel's GROUPBY function for real-time data analysis, dynamic summaries, and actionable insights. Perfect for all skill levels ...

In Microsoft Excel, learn how to report time values by the hour using the underlying date serial value.

Sorting is one of Microsoft Excel's easiest tasks. Click; you're done! At least until you need to sort by multiple columns. For this sort task, you'll need a custom sort. Here's how.