YTL Excel #115: Time Delayed Formula TODAY & IF functions

See how to have cell content appear in your workbook after a certain number of days using the IF and TODAY functions. Time Delayed Formula.

TODAY() TODAY function formula.

Category:

Science & Technology

Tags:

• Excel
• TODAY
• IF
• function
• for
• Copying
• Cells
• Time
• Delayed
• formula
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[ExcelIsFun]

I am currently overwheled at work (80+ hours per week).. No time.. Try:

mrexcel[dot]com/forum

[2009jaxs]

I came across another road block in regards to cell P9 & C9.

Cell P9 is blank with a general number format.

When I enter a number >0 then I want the date & time to appear in cell C9 but not before.

I have tried;

1) =IF(P9="","",NOW()) which give me the date & time with out an entry in P9.

2) =IF(P9="","",C9=NOW()) which when P9 is blank C9 is blank, when I enter a number value C9 read false.

3) =IF(P9>0,0,C9=NOW()) which give me a false.

what I am I doing wrong, forgetting and/or missing.