How to Increment the Month in an Excel Spreadsheet. Unlike incrementing a whole number, incrementing the month of a date requires a little more effort in Excel because the calendar months have ...

Microsoft Excel's Month and Weekday functions output numeric values for a given date. The Month function results in the month numbers, such as "3" for March or "12" for December.

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.

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