AnsweredAssumed Answered

How to back out dates based on final release date

Question asked by BryanWilson on Mar 20, 2013
Latest reply on Mar 21, 2013 by philmodjunk

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!

Outcomes