This is what you can put in cell F6.

=IF(E6="Done",TODAY(),"")

If E6 = done, it will put in today's date, otherwise F6 will remain blank.

Hope this helps.


--
Just a fellow Excel user here to help when I can.....


"Rene" wrote:

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