Hi June

Maybe
=IF(ISTEXT(F8),TODAY(),"")

--
Regards

Roger Govier


"June D" wrote in message
...
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