# Calculating days formula that ends in a working day

Options
✭✭

Hello community,

As the title explains, I am looking for a formula that adds 30 days to a specific date. However, sometimes these dates are during the weekend. I want a formula that would be able to add 30 days to a date. If that answered date is on a Saturday or Sunday, it will go to the closest working date. Please let me know if you need any more info. Thank you!

• ✭✭✭✭
Options

@Adam1234 , sorry , that should just be your date column aswell. Missed out editing that reference after I tested it quickly in my sheet

I'm passionate about helping you leverage the truly awesome power of smartsheet!

https://www.fiverr.com/smartlew

• ✭✭✭✭
Options

=WORKDAY([date]@row,30)

That should do it for you

I'm passionate about helping you leverage the truly awesome power of smartsheet!

https://www.fiverr.com/smartlew

• ✭✭
edited 09/23/22
Options

Hi @SmartLew ,

Thank you for your response. Not quite what I was looking for. I believe this formula gives me an additional 30 working days. I want the formula to show that 30 regular days have passed, and if that answer lands on a Saturday or Sunday, it will give me the next working day. Please let me know if that makes sense. Thank you!

• ✭✭✭✭
Options

gotcha!

try this

=IF(WEEKDAY([Date]@row + 30) = 7, [Date]@row + 32, IF(WEEKDAY([Date]@row + 30) = 1, [Date]@row + 31, [Column8]@row + 30))

This adds 30 days, and then checks if it's a Saturday or Sunday (smartsheet identifies Sunday as Day 1 of the week). If so it adds the extra days to get the date to Monday. if it's not a Saturday or Sunday, it keeps it as 30 days added only.

Let me know if that works for you!

I'm passionate about helping you leverage the truly awesome power of smartsheet!

https://www.fiverr.com/smartlew

• ✭✭
Options

Hi @SmartLew ,

perhaps I am missing something, I'm not quite sure what the [Column 8] is referring to in the end of the formula.

• ✭✭✭✭
Options

@Adam1234 , sorry , that should just be your date column aswell. Missed out editing that reference after I tested it quickly in my sheet

I'm passionate about helping you leverage the truly awesome power of smartsheet!

https://www.fiverr.com/smartlew

• ✭✭
Options

I see where I messed up. Thank you!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!