Home

Excel Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-663568%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-663568%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CFONT%3EHi%20forum%2C%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CFONT%3ELooking%20to%20have%20a%20second%20set%20of%20eyes%20on%20this%20formula%20to%20help%20me%20understand%20what%20I%20am%20doing%20incorrectly.%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CFONT%3EThe%20outcome%20I%20am%20looking%20for%20is%20to%20put%20today's%20date%20in%20if%20the%20cell%20is%20blank%2C%20if%20not%20blank%20then%20perform%20a%20few%20if%20statements%2C%20if%20the%20date%20is%2015%20days%20or%20less%20input%20on-track%2C%20if%20the%20date%20is%2030%20days%20input%20behind%2C%20if%20the%20date%20is%2045%2B%20days%20input%20off-track.%20Hope%20that%20makes%20sense%2C%20trying%20to%20get%20a%20conditional%20format%20to%20show%20if%20we%20are%20meeting%20a%2045%20day%20turn%20around.%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CFONT%3EIF(%24J2%2C%22%22%2CTODAY()%2CIF(%24j2%26lt%3B%3D%24I2%2C%22On-Track%22%2CIF(%24J2%26lt%3B%3D%24I2%20%2B%2030%2C%22Behind%22%2C%22Off-Track%22)))%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CFONT%3EThanks%20for%20the%20help!%3C%2FFONT%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-663568%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-663695%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-663695%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320472%22%20target%3D%22_blank%22%3E%40abundas%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20see%20a%20slight%20change%20required%20in%20the%20first%20part%20of%20your%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20should%20say%20%3DIF(%24J2%3D%22%22%2C%20TODAY()%2C%20and%20not%20%3DIF(%24J2%2C%20%22%22%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(%3CSTRONG%3E%24J2%3D%22%22%2C%3C%2FSTRONG%3ETODAY()%2CIF(%24J2%26lt%3B%3D%24I2%2C%22On-Track%22%2CIF(%24J2%26lt%3B%3D%24I2%20%2B%2030%2C%22Behind%22%2C%22Off-Track%22)))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-666066%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-666066%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20Damien!%20appreciate%20your%20help%20in%20figuring%20out%20what%20I%20was%20missing!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAB%3C%2FP%3E%3C%2FLINGO-BODY%3E
abundas
Occasional Contributor
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

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

@Damien Rosario 

 

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

 

AB

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies