in b1 type
=IF(A1="yes",NOW(),"")
HTH
bill
"Gordon Cartwright" wrote in message
...
Hi...

In cell A1 I want type the word yes and in Cell B1 a
formula that will return the exact date the word Yes was
entered.

Thanks in advance

Gordon.

The problem with your formula (i'd already tried it), is
that the time updates itself when ever you re-open the
file. I need the time stamp to freeze after acknowleding
the input that its been waiting for. Can I avoid this?

GC

-----Original Message-----
in b1 type
=IF(A1="yes",NOW(),"")
HTH
bill
"Gordon Cartwright" wrote in
message
...
Hi...

In cell A1 I want type the word yes and in Cell B1 a
formula that will return the exact date the word Yes was
entered.

Thanks in advance

Gordon.


.