0 Replies Latest reply: Nov 29, 2012 2:38 AM by Ellen Blackwell RSS

    Derive StartDate by subtracting number of week days from FinishDate

    Ellen Blackwell

      Hello Community!

       

      I am working with a 'EndDate' value and have to calculate the 'StartDate' value based on a duration of 17. The easy answer is . . .

       

           AddDays(EndDate, -10) as StartDate

       

      However, when calculating the StartDate, I need to subtract 17 work days and exclude weekends from my calculation.

       

           In simple mathematical terms, I want to solve for EndDate - 17 working days = StartDate

       

      Without both a start and finish date, I can not use the NetworkDays function. (I've reviewed this post: Excluding weekends from one date minus another..; different issue.)

       

      Any suggestions or examples? Either would be greatly appreciated.

       

      Regards,

      Ellen