number of days past due - change to positive number

✭✭
edited 12/09/19

Hello -

I have this formula - =IF(COMP@row = "X", 0, [DUE DATE]@row - TODAY()) in a column entitled "Aging".

If a user marks an item complete with an X, then nothing appears in the aging column. If the due date is in the past by thirty days, the formula produces a -30. If the due date is in the future by 30 days, the formula produces 30.

I'd like the formula to produce nothing if the due date hasn't past and a positive number, not a negative in the Aging Column so if it's thirty days past due, the column will have 30, not -30.

If anyone can help, thanks in advance!

Lisa

• ✭✭

I modified the formula as follows -

=IF(COMP@row = "X", 0, IF([DUE DATE]@row >= TODAY(), 0, [DUE DATE]@row - TODAY()))

now if it's 30 days in the past, it will say -30 and if it's not due for 30 days it will say 0

I'd like it to be a positive 30 if it's overdue by 30 days.

• ✭✭

Solved my own issue, I guess coffee hadn't kicked in yet -

=IF(COMP@row = "X", 0, TODAY() - [DUE DATE]@row)

• ✭✭✭

Hey Lisa,

Glad you found a solution.  I was going to suggest wrapping your formula with the ABS() function to return the Absolute Value (30).  Yours looks much cleaner.

- Jeremy