Determine the Finish Date using NETWORKDAYS
Hi all,
We have a group of tasks that commence on a given date. [ISSUE DATE]
We would like to automatically populate the adjacent cell with a date, which is +5 business days from the ISSUE DATE. I'm assuming we need to use the NETWORKDAYS formula but I can't determine how to achieve this.
Thanks for your assistance.
Regards,
Richard.
Best Answer
-
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Perfect. Thanks @Mark Cronk
-
Hi Mark -
I am trying to do a similar calculation.
Need to calculate [Travel End date] plus 30 days
Formula below returning Invalid argument error. I tried networkday and workday.
=WORKDAY([Travel End date]@row, 30)
Thanks
-
Hi @Tanya Brooks ,
=WORKDAY([Travel End date]@row, 30) should work to add 30 workdays to your Travel End Date.
Confirm that the column the formula is in and the Travel End Date column are both set as Date columns. If the Travel End Date cell is blank you'll get an error so you'll want the final formula to be:
=IFERROR(WORKDAY([Travel End Date]@row,30),"")
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!