Adding + 1 Working Day

Kaleb

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.

L_123

=[Finish Date (Actual)]@row + if(weekday([Finish Date (Actual)]@row) = 6,3,1)

Jeff Reisman

@Kaleb

Try the WORKDAY function:

=WORKDAY([Finish Date (Actual)]@row, 1)

This will return the first working day after the [finish date (actual)] date.

L_123

=[Finish Date (Actual)]@row + if(weekday([Finish Date (Actual)]@row) = 6,3,1)

Jeff Reisman

@Kaleb

Try the WORKDAY function:

=WORKDAY([Finish Date (Actual)]@row, 1)

This will return the first working day after the [finish date (actual)] date.

Kaleb

@Jeff R / @L_123 Both Formulas Worked. Thank you Both!

Mike TV

@L_123

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.

Mike TV

@Kaleb

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))

L_123

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.