In F6 put: =IF(E6="done",TODAY(),"")

But be aware that if "done" appears in E6, the date in F6 will change
everytime the worksheet is recalculated. In otherwords, when you load the
workbook into Excel tomorrow, F6 will have tomorrow's date. If you need to
have a timestamp that does not change, see
http://www.mcgimpsey.com/excel/timestamp.html

Tyro

"Rene" wrote in message
...
I'm trying to enter a formula so that the cell where the formula is being
entered displays the current date, so I wrote in F6
[=TODAY()*(IF(E6="done",TRUE,FALSE))], which works, but when the word
"done"
is deleted F6 then displays 1/01/1900. Can I correct this so that F6 is
blank when "done" is not present?
Thanks to PCLIVE for answering my previous post. Simple and beautiful.
--
Rene - Do appreciate your help