Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Auto Populate Due date
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?
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