Days Remaining until Due Date (minus weekends)
I have a countdown to the due date column, but right now it includes weekends. I would like to have business days only.
My original formula was:
The formula I thought would work was this, but got a #invalid data type error:
Any suggestions? Thank you!
Best Answer
-
Hi @Caryn ,
The NETWORKDAYS formula is slightly different than how you're trying to use it:
So in this case you would want the section of the formula dealing with this to be:
NETWORKDAYS(TODAY(),[Date Due]@row)
If there are any extra holiday days, you can add these in a column (on another sheet if necessary) and then put to have the section of the formula more like this (using a column called "Holidays" in this example):
NETWORKDAYS(TODAY(), [Due Date]@row, Holidays:Holidays)
Hope this is of assistance!
Answers
-
Hi @Caryn ,
The NETWORKDAYS formula is slightly different than how you're trying to use it:
So in this case you would want the section of the formula dealing with this to be:
NETWORKDAYS(TODAY(),[Date Due]@row)
If there are any extra holiday days, you can add these in a column (on another sheet if necessary) and then put to have the section of the formula more like this (using a column called "Holidays" in this example):
NETWORKDAYS(TODAY(), [Due Date]@row, Holidays:Holidays)
Hope this is of assistance!
-
Thank you very much! It worked:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!