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

Bookkeepers, project managers, HR departments and more use the Excel Date & Time functions WEEKNUM, ISOWEEKNUM, WORKDAY, WORKDAY.INTL to calculate time. Here's how.

The TIMEVALUE function in Microsoft Excel is a Date and Time function, and its purpose is to convert a time in the form of text to a serial number. It is used to convert text representations of ...

The NETWORKDAYS function in Excel is a date and time function that returns the number of whole working days between Start_date and End_date.

How to Use Month and Weekday Functions in Excel. 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 ...

Microsoft Word has a date field, but it's not easy to use in an expression. If you need to update dates in a document, use Excel to calculate the dates and then run a mail merge.