• 464K Members
• 7,949 Online
• 561K Conversations

## Excel Formula Help

Occasional Contributor

# 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!
2 Replies

# Re: Excel Formula Help

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

# Re: Excel Formula Help

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

AB

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies