Auto Populate Due date

Quece Goh

Hi,

 

I manage to get SS auto populate the due-date base on the start date. But is it possible to make the due date calculation is not including the weekend?

Example:

Start Date = 19 May 2017, Friday

Due Date is after 4 day of the start date, it should be 23 May 2017.

But becasue of the Sat & Sun, the due date should delay another 2 more days. So it should be  25 May 2017. 

Now i am using this formula to get my due date : =DATEONLY([Date Confirm]5 + 4).

Please help. Thanks

 

Cheers

Quece

 

Mike Wilday

You will want to use the formula,

         =Workdays([Date Confirm]5, 4)

That will return the next workday, 4 days after the Date Confirm5 date. It will auto formulate it as a date so you shouldn't need to use the DATEONLY formula. Here is more on the workday formula: 

https://help.smartsheet.com/articles/775363-using-formulas#workday