WORKDAY formula to prevent auto planning on weekend days
In my sheet I would like to use a date and add 3 days automatically in another cell, but I want to make sure the date that automatically appears is not on a Sunday or Saturday. I have looked in the Formula Sheet which is provided by Smartsheets, but can only find formulas which calculate the amount of workdays between two dates. Does anyone have the golden tip to prevent me from planning on weekend days?
Answers
-
Hi Willemijn,
It seems you need to setup your sheet as a Project sheet that includes columns of Start date, End date, Duration. You also setup working days (Mon-Fri).
Look at the below sreen shot of a Project formated sheet then appy to your sheet.
Hope that helps.
Gia Thinh Technology - Smartsheet Solution Partner.
-
Please, I noticed that when I do what you sugested the column "due date" is not able anymore to accpect formulas. How can I solve this?
my grid:
Start Date | SLA | Due Date
04/05/2022 | 3 | ?? formula
I would like to have due date with formulas considering only workdays.
Thanks in advance.
BR
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!