robby@brays.net

Calendar Calculation to stay in work week

Discussion created by robby@brays.net on May 4, 2014
Latest reply on May 10, 2014 by robby@brays.net

Hello,

So I am trying to come up with a formula, that if I have a delivery date, My due date will be 2 days before the delivery date. Then I have 3 more processes that lets say, process 1 needs to be done 1 day before the due date. Process 2 needs to be done 2 days before the due date. Process 3 needs to be done 3 days before the due date ect.

What I am trying to do, is have a calculation for each of the calandar fields to stack the dates in the right order, AND not allow the date to fall on a weekend.

Thanks and I really look forward to anyones help on this.

Robby

Outcomes