preventing date from changing

[Dave]

I have an If condition that sets the date to "today()" true or "today() + 1"
if false. My question is how do I prevent the date from changing? If the
date is set for today, then tomorrow I don't want to "update". How can this
be done?

thanks

 

[Debra Dalgleish]

You could copy the cell, and paste as values, before you close the file.
(Edit>Paste Special, Values)

Or, you could enter today's date in a cell in the row (Ctrl+; ), then
refer to that cell in the formula. For example, instead of:

=IF(A2="Local",TODAY(),TODAY()+1)

enter:

=IF(A2="Local",F2,F2+1)

where F2 contains the current date.