Date and time

  • Thread starter Thread starter gsaenz
  • Start date Start date
G

gsaenz

Can I have excel display the current date and time? Time is not tha
important but date would be great
 
=TODAY()

will update with every calculation or manually pressing F9

=NOW()

date and time
 
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
 
Back
Top