How to back out dates based on final release date
I'm looking for help on how to formulate a date based on a predetermined release date and a predetermined formula on how long something should take.
For example, in my "Release Deadline" field I have 3/28/13.
I want to populate the "Layout Review" field, knowing that it should take place 3 days before the "Release Deadline", which in this case should be 3/25/13.
To make it more complicated, I would like to also have the weekends taken into account in this formula. So if the "Release Deadline" were 3/27/13 the formula would know that 3/24/13 is a Sunday and move the date to 3/22/13.
Thanks in advance!