The Excel NOW function works the same as the TODAY function, however it returns both the current date and time when the spreadsheet is open. This is handy for a master spreadsheet you may use ...

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

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 ...

How to Calculate Past Due Date on MS Excel. Excel's EDATE and NOW functions can be used to track when an account is overdue, and let the person managing the account know when to send a reminder ...

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.

Excel for the web now supports conditional formatting, and the interface is easier to use than the desktop edition. Susan Harkins shows you how to use it.