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