To insert the current time, press Ctrl+Shift+; (semi-colon). To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon).

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 …

This article describes the formula syntax and usage of the TODAY function in Microsoft Excel. Description The TODAY function returns the serial number of the current date. The serial number is …

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

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.

In the Insert AutoText box, click Field. In the Select a Field or Group dialog box, select the field containing the date or time you want to appear in the header or footer.

Feb 2, 2012 · If you don't like the default date format, you can choose another date format in Excel, such as " February 2, 2012" or " 2/2/12". You can also create your own custom format in Excel desktop.

Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.

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.

Feb 2, 2009 · To enter a specific date or time format, such as January 2010, you can format it as text by selecting Text in the Category list. To quickly enter the current date in your worksheet, select any …