topic Re: How to do cumputation with working days in QlikView https://community.qlik.com/t5/QlikView/How-to-do-cumputation-with-working-days/m-p/1110922#M909517 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>NetWorkDays(StartDate, EndDate)</STRONG></P><P></P><P>In your case -&gt; <STRONG style="font-size: 13.3333px;">NetWorkDays(MakeDate(2016,1,29), MakeDate(2016,2,1))</STRONG></P></BODY></HTML> Tue, 14 Jun 2016 15:27:34 GMT sunny_talwar 2016-06-14T15:27:34Z How to do cumputation with working days https://community.qlik.com/t5/QlikView/How-to-do-cumputation-with-working-days/m-p/1110921#M909516 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I want to do computations between two dates. For example:</P><P></P><P>(monday)&nbsp; 01.02.16&nbsp;&nbsp; -&nbsp;&nbsp; 29.01.16&nbsp; (friday).</P><P></P><P>Unfortunately the system is giving me back the result of 3 in fact that it count the weekend in between. I want to see 1 as an result if I think in working days.</P><P></P><P>Is there as easy option to tell the system to ignore sat und sun in the computation?&nbsp; or the other way around on respect days from monday fto friday?</P><P></P><P>Thx for help</P><P>Heiko</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-do-cumputation-with-working-days/m-p/1110921#M909516 2020-11-25T16:16:04Z Re: How to do cumputation with working days https://community.qlik.com/t5/QlikView/How-to-do-cumputation-with-working-days/m-p/1110922#M909517 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>NetWorkDays(StartDate, EndDate)</STRONG></P><P></P><P>In your case -&gt; <STRONG style="font-size: 13.3333px;">NetWorkDays(MakeDate(2016,1,29), MakeDate(2016,2,1))</STRONG></P></BODY></HTML> Tue, 14 Jun 2016 15:27:34 GMT https://community.qlik.com/t5/QlikView/How-to-do-cumputation-with-working-days/m-p/1110922#M909517 sunny_talwar 2016-06-14T15:27:34Z Re: How to do cumputation with working days https://community.qlik.com/t5/QlikView/How-to-do-cumputation-with-working-days/m-p/1110923#M909518 <HTML><HEAD></HEAD><BODY><P>Hello Sunny , thx for your great help. </P></BODY></HTML> Wed, 15 Jun 2016 14:05:34 GMT https://community.qlik.com/t5/QlikView/How-to-do-cumputation-with-working-days/m-p/1110923#M909518 2016-06-15T14:05:34Z