Fill Feature Open your spreadsheet in Microsoft Excel and locate the date you wish to increment. Click and drag your mouse from the cell containing the date to the last cell in the range.

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