2 Replies Latest reply: Apr 13, 2015 5:57 AM by Gerald Britt RSS

    networking days between two dates per month

      Hi everyone,

       

      I am trying to calculate the working days between two dates grouped by month.

      Lets say for example I have a project that starts 11/05/2014 has duration of 240 working days, so it ends on LastWorkDate('11/05/2014',240) which is 10/04/2015.

       

      I want to be able to calculate the number of working days per month in the calendar for this project. Obviously the starting month and the ending month of the project would have less working days as they will be calculated in a different way.

       

      I was using NetWorkDays and LastWorkDate to make my expression work with no luck

       

      Any good ideas??