How to set up an aging formula that only runs if the item is open and not closed

%3CLINGO-SUB%20id%3D%22lingo-sub-1512176%22%20slang%3D%22en-US%22%3EHow%20to%20set%20up%20an%20aging%20formula%20that%20only%20runs%20if%20the%20item%20is%20open%20and%20not%20closed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1512176%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20attempting%20to%20create%20a%20formula%20that%20will%20only%20run%20if%20one%20of%20the%20cells%20is%20labeled%20O.%20O%20stands%20for%20open%20while%20C%20stands%20for%20closed.%20I%20am%20wanting%20to%20setup%20a%20formula%20that%20will%20show%20the%20age%20of%20an%20open%20case%2C%20only%20if%20it%20is%20open.%20I%20have%20the%20dates%20column%2C%20status%20column%2C%20and%20a%20aging%20column%20that%20I%20will%20use%20for%20the%20aging%20output.%20I%20have%20researched%20this%20for%20a%20solid%20hour%20and%20come%20up%20with%20nothing%20that%20fits%20my%20situation.%20I%20am%20fairly%20new%20to%20Excel%20and%20still%20learning%20as%20I%20go.%20If%20anyone%20has%20some%20suggestions%2C%20it%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20y'alls%20help!%3C%2FP%3E%3CP%3ECarter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1512176%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1513201%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20set%20up%20an%20aging%20formula%20that%20only%20runs%20if%20the%20item%20is%20open%20and%20not%20closed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1513201%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F685691%22%20target%3D%22_blank%22%3E%40CarterDRH%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECarter%2C%20perhaps%20you%20may%20share%20small%20sample%20file.%20It's%20not%20clear%20what%20do%20you%20mean%2C%20e.g.%26nbsp%3B%3CSPAN%3E%3CSTRONG%3Ewhile%20C%20stands%20for%20closed%3C%2FSTRONG%3E%20-%20what%20is%20C%2C%20how%20Excel%20knows%20it's%20closed%20or%20not%2C%20etc.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I am attempting to create a formula that will only run if one of the cells is labeled O. O stands for open while C stands for closed. I am wanting to setup a formula that will show the age of an open case, only if it is open. I have the dates column, status column, and a aging column that I will use for the aging output. I have researched this for a solid hour and come up with nothing that fits my situation. I am fairly new to Excel and still learning as I go. If anyone has some suggestions, it would be greatly appreciated.

 

Thanks for y'alls help!

Carter

1 Reply

@CarterDRH 

Carter, perhaps you may share small sample file. It's not clear what do you mean, e.g. while C stands for closed - what is C, how Excel knows it's closed or not, etc.