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.