Network Days Remaining Until Due Date

Options

With this formula for the "Days Remaining Until Due Date," it should be "0" when the due date is today and it should be "-1" when it is only one day past the due date.

=IF(ISBLANK([Returned To]@row), NETWORKDAYS(TODAY(), [Date Due]@row), "Complete")

Can someone let me how to fix it or if there is an inherent error built into the Network Days countdown?

Thank you!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!