Counting Past Due Days

FlyFlip

Hello!

I'm hoping you can help me with a formula.

I have 3 columns: Due Date, Over Due Days, and Paid Date.

I want the "Over Due Days" to calculate how many working days are past due based on the "Due Date" and today's date while keeping the "paid date" cell blank.

Once I enter the "Paid Date" I would like to keep the "over due days" in the cell so we can reference the data for the future.

Thanks ahead of time for your help!

Paul Newcome

Try this:

=NETWORKDAYS([Due Date]@row, IF([Paid Date]@row <> "", [Paid Date]@row, TODAY()))