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.

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.

If you want the exact date or time a form was printed to be reflected in the printed form, you can use AutoText codes in the Insert Header and Insert Footer dialog boxes to accomplish this task.

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.

How to calculate the number of days, months, or years between two dates using the DATEIF function in Excel.

Drag the fill handle across the adjacent cells that you want to fill with sequential dates. Select the fill handle at the lower-right corner of the cell, hold down, and drag to fill the rest of the series.

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

Use Excel functions including TEXT, TODAY, and DATEVALUE to insert or convert a date to a Julian date.

Feb 2, 2009 · To insert a date that will update to the current date each time you reopen a worksheet or recalculate a formula, type =TODAY () in an empty cell, and then press ENTER.