Excel automatically recognizes common formats, such as "3/17/2012," "Mar 17, 2012" or "17 Mar 2012." Use the Month function to extract the month number from a referenced cell.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

How many days? Excel doesn’t offer a function that returns the total number of days in a specified month, and before EOMONTH () came around, an expression to do so was complex.

This month’s column introduces Excel’s GROUPBY function as a PivotTable alternative.

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