How do I calculate an overdue date?

I have three potential approval date columns. How do I calculate the true overdue time in days?

My current formula doesn't account for approval dates 1, 2, or 3 being populated to signal completion...

=IF([Due Date]@row <= TODAY(), NETWORKDAYS([Due Date]@row, TODAY()) - 1, "")

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!