Forum Discussion

abundas's avatar
abundas
Copper Contributor
Jun 02, 2019

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, 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!
excel
Formulas and Functions

2 Replies

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor
    Jun 02, 2019

    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