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.