Counting Past Due Days
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!
Help Article Resources
Check out the Formula Handbook template!