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 add a monthly balance in Excel As you’ve seen, a daily balance requires only a simple IF () function to match dates before returning the balance for each day.

If numbers keep changing to dates automatically in Excel or if Excel changes dates to random numbers then this post will help you fix the issue.