Adding + 1 Working Day
Good Day Smartsheet Community:
I am trying to Add 1 Day to this Formula but I want the 1 Day to be a Working Day, not Saturday or Sunday.
Current Formula:
=[Finish Date (Actual)]@row + 1
Thanks for the Help in Advance.
Best Answers
-
=[Finish Date (Actual)]@row + if(weekday([Finish Date (Actual)]@row) = 6,3,1)
-
Try the WORKDAY function:
=WORKDAY([Finish Date (Actual)]@row, 1)
This will return the first working day after the [finish date (actual)] date.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
=[Finish Date (Actual)]@row + if(weekday([Finish Date (Actual)]@row) = 6,3,1)
-
Try the WORKDAY function:
=WORKDAY([Finish Date (Actual)]@row, 1)
This will return the first working day after the [finish date (actual)] date.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
-
That almost works. However, if you use tomorrow's date which is Saturday 05/21/2022 it returns Sunday 05/22/2022 as the +1 date. I'm not familiar enough with this formula to suggest a fix. If I figure something out I'll post it.
-
I fixed it. Here you go:
=[Finish Date (Actual)]@row + IF(WEEKDAY([Finish Date (Actual)]@row) = 6, 3, IF(WEEKDAY([Finish Date (Actual)]@row) = 7, 2, 1))
-
good call @Mike TV
I forgot saturday. You can simplify that further using a modulus, but I think @Jeff Reisman has the best option for a simpler formula.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Hi! I cannot figure this out. I have a "% Complete" column (0, 25, 50, 75, 90, 100, Cancelled). I made a simple checkbox column that should be checked if the item's "% Complete" value is equal to anyt…
- This formula keeps coming up as #UNPARSEABLE. I have checked the name of the columns, they are correct. Any ideas? I am trying to show the days remaining in a project. =IF([% Complete]@row = 1, "", NE…
- Hi All! I´m trying to find the error in this formula but have not been able to find the solution after many attempts. Any ideas? =IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF(…
