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

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.

You can change the date & time format in Google Sheets & Excel Online using this guide. Use different date & time formats in spreadsheets.

Press "Ctrl-V" on your keyboard to paste your copied date into the selected cell. Excel automatically formats the date to the default date format set for the current spreadsheet.