Date Stamp

[Guest]

Hi there

I have made a DateStamp using this formula:

=TEXT(TODAY(),"d/mm/yyyy")

But when i go back to the work sheet the next day it a automatically
cahanges the date. Is there any way to stop the automatic update so the date
will remain the same?

 

[Rick Rothstein \(MVP - VB\)]

The TODAY function, as well as the NOW function, do what they say... produce
today's (or now's) date... if the date changes, then the functions return
the then today or now date. If you want to place a date-stamp in a cell,
just select the cell and press Ctrl+; (that is the Control Key coupled with
the Semi-Colon Key). If you want to put a time-stamp in a cell, press
Ctrl+Shift+; (Control and Shift coupled with the Semi-Colon Key).

Rick

 

[JE McGimpsey]

See

http://www.mcgimpsey.com/excel/timestamp.html