MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Inputting current date

Posted by Greg F on September 04, 2001 1:47 PM

Is there a way in Excel that you can have the current date in a cell. Then each time you open the file it will be updated. This sounds like a simple task, but for some reason, I am having trouble finding the best way of doing this! Any advice would be greatly appreciated.

Posted by Tom Urtis on September 04, 2001 1:48 PM

The formula is: