1 Reply Latest reply on Nov 4, 2012 7:08 AM by comment

    Date calculation excluding weekends

    hawkeye

      Hello all,

       

      I am trying to work out a calculation field that 1) has a start date and 2) a number of days but needs to exclude weekends.

       

      So the start date might be 5 Nov 2012 and the project has 40 days work only on weekdays and the output is the end date.

       

      Ideally some assessment of public holidays (local) would also be helpful as they would need to be excluded as well.

       

      Regards Hawkeye