Start of Aging

So my aging should start counting 7 days after the date of inspection (I didnt include it in the screenshot). Considering that, some of the dates in the start of aging doesnt happen yet. As you can see, my formula for aging is =Today-Start of aging. If the date in start of aging is more than the date today, it is giving me a negative number.

Is it possible that the Aging wont compute if the start of aging date does not happen yet? Hope I can receive immediate answer. Thank you.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!