Remaining workdays formula help

crystal.schroeder

Hello,

I am trying to figure out how to calculate the days until due and days past due and the formula I am using is not working - should it say 1 day left when today is the due date??

Carson Penticuff

The NETWORKDAYS() function is date inclusive, meaning it will count both the start date and end date. This will result in 1 day if the due date is today. You can get around this by always subtracting one from the result:

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

Carson Penticuff

You may want to verify your timezone is set correctly for your account.

crystal.schroeder

I did check, its correct.

Carson Penticuff

The NETWORKDAYS() function is date inclusive, meaning it will count both the start date and end date. This will result in 1 day if the due date is today. You can get around this by always subtracting one from the result:

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