Date and Time Stamp in Excel
 

Ok, I know to most of you this question is really simple,
but I've had NO formal training with Excel and am
learning as I go! What are the formula's to have a spread
sheet AUTOMATIALLY update the date and time each time you
open the file? Thanks!

Date and Time Stamp in Excel
 

Just to add:
Those will also update each time the sheet is recalculated.

--
Regards,
Tom Ogilvy

"Paul B" wrote in message
...
Todd, =NOW() will give you the date and time, =TODAY() will give you the
date

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"Todd" wrote in message
...
Ok, I know to most of you this question is really simple,
but I've had NO formal training with Excel and am
learning as I go! What are the formula's to have a spread
sheet AUTOMATIALLY update the date and time each time you
open the file? Thanks!