TODAY()

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to make the TODAY() value stick once it is populated. For instance, I want yesterday's date to stay as yesterday's date and not change to today's date. Thanks in advance for any advice.
 
Hi

No, all functions recalculate on sheet entries. You must either type todays
date, enter it with Ctrl ; (that's a semicolon) or have a macro entering it.

--
HTH. Best wishes Harald
Followup to newsgroup only please

JakeyIE said:
Is there a way to make the TODAY() value stick once it is populated. For
Click to expand...
instance, I want yesterday's date to stay as yesterday's date and not change
to today's date. Thanks in advance for any advice.
 
Back
Top