Combine Today() with If function
 

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

Combine Today() with If function
 

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

Combine Today() with If function
 

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