| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Today Function | New Users to Excel | |||
| Today() & Now() function | Excel Worksheet Functions | |||
| Can you do a function like =TODAY() PLUS 1? | Excel Worksheet Functions | |||
| Could anyone help me with (Today function), please? | New Users to Excel | |||
| TODAY Function | Excel Worksheet Functions | |||
Threaded Mode
