Nested If Using TODAY Function

[Robbie]

I'm having issues with a nested IF using the TODAY function. Basically, in
one worksheet I enter the training date in DD-MMM-YY format or a "P" for "In
Progress." However, the "P" works for copying into another worksheet, but
having an empty cell or the date will give me the task length. Here's my
formula:

=IF(AADO!B13="P","P",IF(AADO!B13<=TODAY(),1.75,""))

If the cell, AADO!B13, equals "P" the "P" appears in AADOHours!B13.
However, if the cell is empty or has the training date, the task length, 1.75
hours, is entered. The end result I'm looking for is if the cell, AADO!B13
(for example) is empty, then I would like AADOHours!B13 to remain empty until
"P" is entered or the training date.

Thanks, Robbie

 

[Max]

Try strapping on an additional IF check upfront:
=IF(AADO!B13="","",IF(AADO!B13="P","P",IF(AADO!B13<=TODAY(),1.75,"")))

 

[Robbie]

Max, you rock! Thanks, dude!

 

[Max]

Welcome, Michael.