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.
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
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
