I have entered the following formula into my spreadsheet:
=IF(F8="Complete",TODAY(),"")
The formula enters today's date when I enter the word "complete" into F8.
However, tomorrow, the formula will update to tomorrow's date. Ho can I keep
the date from changing every day after the initial entry?
Thanks,
--
J.P.