Date Formula to exclude weekends

Regan Raj

Hi Friends,

 

I need a formula that would result in a Date = Today + 1 day, but if Date is on a Saturday or Sunday, Date should be the following Monday.

I also need the same for Date = Today + 3 days but the calculated Date should add 3 week days (Mon - Fri) and not be a Saterday or Sunday.

Hope this make sense?

Kinsen Siu

Using the workday function should solve your problem.  

Shaine Greenwood

Kinsen's right, the WORKDAY() function should do what you need. Check out our Help Center article for more information: https://help.smartsheet.com/articles/775363-using-formulas#workday