topic Re: networking days between two dates per month in QlikView https://community.qlik.com/t5/QlikView/networking-days-between-two-dates-per-month/m-p/586169#M679339 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P></P><P>How would a calculate workdays, if there is another column, that indicates the 'current' status, linked to the date?</P></BODY></HTML> Mon, 13 Apr 2015 09:57:26 GMT 2015-04-13T09:57:26Z networking days between two dates per month https://community.qlik.com/t5/QlikView/networking-days-between-two-dates-per-month/m-p/586167#M679337 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I am trying to calculate the working days between two dates grouped by month.</P><P>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.</P><P></P><P>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.</P><P></P><P>I was using NetWorkDays and LastWorkDate to make my expression work with no luck <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P></P><P>Any good ideas??</P></BODY></HTML> Wed, 16 Apr 2014 13:05:40 GMT https://community.qlik.com/t5/QlikView/networking-days-between-two-dates-per-month/m-p/586167#M679337 2014-04-16T13:05:40Z Re: networking days between two dates per month https://community.qlik.com/t5/QlikView/networking-days-between-two-dates-per-month/m-p/586168#M679338 <HTML><HEAD></HEAD><BODY><P>If you're using month as a dimension in a chart then <EM>networkdays(min(MyDate), max(MyDate))</EM> should show you the net working days per month</P></BODY></HTML> Wed, 16 Apr 2014 13:37:47 GMT https://community.qlik.com/t5/QlikView/networking-days-between-two-dates-per-month/m-p/586168#M679338 Gysbert_Wassenaar 2014-04-16T13:37:47Z Re: networking days between two dates per month https://community.qlik.com/t5/QlikView/networking-days-between-two-dates-per-month/m-p/586169#M679339 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P></P><P>How would a calculate workdays, if there is another column, that indicates the 'current' status, linked to the date?</P></BODY></HTML> Mon, 13 Apr 2015 09:57:26 GMT https://community.qlik.com/t5/QlikView/networking-days-between-two-dates-per-month/m-p/586169#M679339 2015-04-13T09:57:26Z