Network Days Remaining Until Due Date

Caryn

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!

Mike TV

@Caryn

Did you try this?

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

Caryn

Thank you, Mike! That did help with the -2 part (now it says -1 as it is supposed to) but it did not change the where it should be "0" when the due date is today. It still says 1 on the due date.

Mike TV

@Caryn

Try this then:

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

Caryn

That does work for the day it is due, but it doesn't change the entire countdown. Example: It changes "1" to "0", but doesn't do anything for the changing the "2" to "1" etc.