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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!