To insert the current date or time so that it is updatable, use the TODAY and NOW functions, as shown in the following example. For more information about how to use these functions, see TODAY …

The TODAY function is useful when you need to have the current date displayed on a worksheet, regardless of when you open the workbook. It is also useful for calculating intervals.

You can enter a negative number to subtract days from your start date, and a positive number to add to your date. In cell C2, enter =A2+B2, and copy down as needed.

To add the current date at the time of printing to the bottom of every printed page, simply insert the date in the worksheet footer. Similarly, you can also add the date to the top of every printed page.

The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you …

Use Excel's DATE function when you need to take three separate values and combine them to form a date.

To print the short version of today's date in the header or footer, click Short Date. With this setting selected, the short date format would print as, for example, 09/22/05 for English (United States), …

From the Header & Footer Ribbon menu, click Insert Date or Insert Time. You can also insert the Page Number, Number of Pages, File Path, File Name and Sheet Name.

Suppose you want to create a grammatically correct sentence from several columns of data for a mass mailing or format dates with text without affecting formulas that use those dates. To combine text …

Use the DATEDIF function when you want to calculate the difference between two dates. First put a start date in a cell, and an end date in another. Then type a formula like one of the following. Note: If the …