Remaining workdays formula help
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??
Best Answer
-
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
Answers
-
You may want to verify your timezone is set correctly for your account.
-
I did check, its correct.
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!