# Adding + 1 Working Day

Options
✭✭✭✭

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.

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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.

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
edited 05/20/22
Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!