| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| 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 | |||
Linear Mode
