Don't know exact;y what you want to do. Look at the following:
=TODAY() displays the current date. This date is volatile and will change
(update) when ever the sheet is calculated.
=NOW() displays the current date and time. Same volatility as above.
You can manually do the following:
Ctrl: Time (Ctrl+Shift+Colon)
Ctrl; Date (Ctrl + SemiColon)
These are not volatile and will not change.
If you want the current date or date and time placed in a cell automatically
upon the occurrence of some event (enter something in some other cell, open
the file, close the file, etc.), use the VBA code:
Range(A1).Value=Date
Range(A1).Value=Now
The above date and time is not volatile and will not change. HTH Otto
