6 Replies Latest reply on Dec 14, 2009 5:19 PM by Yizwitz

    Date calc so end date doesn't fall on weekend or holiday

    Yizwitz

      Title

      Date calc so end date doesn't fall on weekend or holiday

      Post

      I'm a newer FM Pro 10 user.  I've looked through the forum for an answer to this issue but I don't quite find the answer. 

       

      I need to do a straightforward date calculation to determine due dates for certain items based on an initiation date for the process I'm tracking.  The deadlines simply need to be adjusted so that if the deadline falls on a Saturday or Sunday, it gets kicked ahead to the following Monday.  Similarly, if the deadline falls on a holiday (I have a list of the holidays through the calendar year), the deadline needs to be kicked to the next day.  So, for example, if the deadline falls on Christmas Day of 2009, which is a Friday, the deadline should then be set for Monday, December 28 (because Christmas falls on a Friday this year).  

       

      I don't need to worry about skipping weekends in the calculation.  All I need to worry about is whether the deadline falls on a weekend or holiday.  

       

      Any assistance would be appreciated.  Thanks a lot.