When you enter a date that's formatted with slashes, Excel will recognize it as a date ... The menu has two formats for dates: short date and long date. Short date displays months and days ...

How to fix the date filter not grouping in Excel If the Excel Date Filter is not grouping by month, follow these suggestions to fix the issue: Select all rows when grouping dates in Excel Enable ...