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
Check out the Formula Handbook template!