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

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. The Weekday function ...

Excel Functions for Adding a Percentage Markup. Microsoft Excel provides numerous mathematical functions that save time and improve accuracy in data entry. Percentage markups are used in retail ...

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 shows how to use the remarkably versatile AGGREGATE function in Excel.