Excel Formula Help

[abundas]

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, if not blank then perform a few if statements, if the date is 15 days or less input on-track, if the date is 30 days input behind, if the date is 45+ days input off-track. Hope that makes sense, trying to get a conditional format to show if we are meeting a 45 day turn around.

IF($J2,"",TODAY(),IF($j2<=$I2,"On-Track",IF($J2<=$I2 + 30,"Behind","Off-Track")))

Thanks for the help!

[#2]

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

[#3]

@Damien Rosario 

Thank you Damien! appreciate your help in figuring out what I was missing!

AB