Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
If you're using month as a dimension in a chart then networkdays(min(MyDate), max(MyDate)) should show you the net working days per month
Hi Gysbert,
How would a calculate workdays, if there is another column, that indicates the 'current' status, linked to the date?