To insert the date, type the date, for example 2/2, and then select Home > Number Format dropdown > Short Date or Long Date. To insert the time, type the time, and then select Home …

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

You can add or subtract a number of days to or from a date by using a simple formula, or you can use worksheet functions that are designed to work specifically with dates in Excel.

Under Insert controls, click Date Picker. In the Date Picker Binding dialog box, select the field in which you want to store the date picker data, and then click OK.

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.

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 pick a different one in Excel, like February 2, 2012 or 2/2/12. You can also create your own custom format in Excel.

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 …

Insert the current date and time into a document, either as plain text or a field that updates automatically.

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.