Start of Aging

Mariniel Bautista

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.

Paul Newcome

Try something like this...

=IF(TODAY()>= [Start of Aging]@row, TODAY() - [Start of Aging]@row)