Days past due

Samuel Dowdy Jr.

I am trying to track days past due in a cell until a date is entered in another cell. I don't have issues with the formula tracking the days but I want the formula to zero out when the date is entered in another cell.

days past due would = 0 if the invoice status is "Paid"

Paul Newcome

Try something like this...

=IF([Invoice Status]@row = "Paid", 0, original formula here)