MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Inserting Current Date Into Spreadsheet


Posted by john on June 29, 2001 12:58 PM

Does anyone know how to insert the current date into the regular body of the spreadsheet automatically. Not in the header?


Posted by Connie on June 29, 2001 1:09 PM

John,
you can use the =TODAY() in any cell in your spreadsheet and it will reflect today's date (based on your machine's date setting).
Connie

Posted by mseyf on June 29, 2001 1:41 PM

Ctr+; (Ctrl semicolon) will insert the current date in a cell