Counting Past Due Days
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!
Answers
-
Try this:
=NETWORKDAYS([Due Date]@row, IF([Paid Date]@row <> "", [Paid Date]@row, TODAY()))
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!