8 Replies Latest reply on Mar 21, 2013 9:44 AM by philmodjunk

    How to back out dates based on final release date

    BryanWilson

      Title

      How to back out dates based on final release date

      Post

           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!