number of days past due - change to positive number
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!