Automated due date for 2 "Saturdays" from request date?
Travis Griffin
✭✭✭
I know you can automate dates with a command like this:
=[Request Date]1 + 21
That creates a date 21 days in future.
But our change windows are on Saturdays. Is there a way to do a similar formula to say, "automated due date is 2 Saturdays from a date?
Best Answer
-
Try this:
=([Request Date]1 + (7 - WEEKDAY([Request Date]1)) + 7)
Answers
-
Try this:
=([Request Date]1 + (7 - WEEKDAY([Request Date]1)) + 7)
-
Amazing! Thank you.
-
You're welcome, @Travis Griffin . If you ever need this again, but for a different day of the week, just change the first 7 (before the Weekday) to the number that corresponds with the day of the week that you need. 1 being Sunday through to 7 being Saturday.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives