Help on creating an AGING using If, And Or Function?

Noel Odalager

Hi

Help anyone, I need to compute an "AGING" when date today is past due date, and if the status is either "Yet to start" or "In Progress"

I keep messing with the parenthesis…🤔

Protonsponge

Hello @Noel Odalager,

This formula might help you here. It is possible to have this work without the need of your [Date today] column if you wanted using the TODAY function.

=IF(ISBLANK([DUE DATE]@row), "", IF(AND([DUE DATE]@row < TODAY(), OR(STATUS@row = "yet to start", STATUS@row = "In progress")), "AGING", ""))

All seems to be working in the demo below,

I hope that is helpful to you in someway,

Protonsponge