Forum Discussion
Excel Formula Help
Hi forum, Looking to have a second set of eyes on this formula to help me understand what I am doing incorrectly. The outcome I am looking for is to put today's date in if the cell is blank, ...
Hi abundas
I see a slight change required in the first part of your formula:
It should say =IF($J2="", TODAY(), and not =IF($J2, "",
=IF($J2="",TODAY(),IF($J2<=$I2,"On-Track",IF($J2<=$I2 + 30,"Behind","Off-Track")))
Hope that helps?
Cheers
Damien
