This question is so similar to the one that I have....

how could I accomplish this..=IF(F8="Complete",TODAY(),"")

BUT with any text (not a specific word like 'Complete') and in the situation
where any change in a row (a few columns with text and a date column) will
automatically update the date.

Thanks
June


"Dave Peterson" wrote:

You can use a shortcut key of ctrl-semicolon (ctrl-;) to enter the static time.

Or you can use a macro to plop in the date/time.

J.E. McGimpsey shows a way to put a time stamp on the same row when something
changes:

http://www.mcgimpsey.com/excel/timestamp.html

J.P. wrote:

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.

--

Dave Peterson