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

Boolean logic: The method used to evaluate conditions, returning either TRUE or FALSE. Logical functions: The primary logical functions in Excel that enable you to apply Boolean logic are AND, OR, XOR ...

If Microsoft Excel does not recognize dates, then there is something wrong with the formatting. Use any of the methods mentioned here to format cells perfectly.

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.

There's more to Excel's Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows.