topic Re: how to get count of working days between two dates in QlikView https://community.qlik.com/t5/QlikView/how-to-get-count-of-working-days-between-two-dates/m-p/775313#M274916 <HTML><HEAD></HEAD><BODY><P>Hi Jitendra,</P><P></P><P>Please use the function: <SPAN style="font-size: 10pt; line-height: 1.5em;">NetWorkDays(from date,to date).</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Pooja<BR /></SPAN></P></BODY></HTML> Wed, 19 Nov 2014 07:04:28 GMT 2014-11-19T07:04:28Z how to get count of working days between two dates https://community.qlik.com/t5/QlikView/how-to-get-count-of-working-days-between-two-dates/m-p/775311#M274914 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>i want to count no. of working days between two dates. kindly help.</P></BODY></HTML> Wed, 19 Nov 2014 06:58:03 GMT https://community.qlik.com/t5/QlikView/how-to-get-count-of-working-days-between-two-dates/m-p/775311#M274914 2014-11-19T06:58:03Z Re: how to get count of working days between two dates https://community.qlik.com/t5/QlikView/how-to-get-count-of-working-days-between-two-dates/m-p/775312#M274915 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>You can use Network days function to get the same.</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">=</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">networkdays([start date], [finish date]).</SPAN></P></BODY></HTML> Wed, 19 Nov 2014 07:02:22 GMT https://community.qlik.com/t5/QlikView/how-to-get-count-of-working-days-between-two-dates/m-p/775312#M274915 ashwanin 2014-11-19T07:02:22Z Re: how to get count of working days between two dates https://community.qlik.com/t5/QlikView/how-to-get-count-of-working-days-between-two-dates/m-p/775313#M274916 <HTML><HEAD></HEAD><BODY><P>Hi Jitendra,</P><P></P><P>Please use the function: <SPAN style="font-size: 10pt; line-height: 1.5em;">NetWorkDays(from date,to date).</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Pooja<BR /></SPAN></P></BODY></HTML> Wed, 19 Nov 2014 07:04:28 GMT https://community.qlik.com/t5/QlikView/how-to-get-count-of-working-days-between-two-dates/m-p/775313#M274916 2014-11-19T07:04:28Z Re: how to get count of working days between two dates https://community.qlik.com/t5/QlikView/how-to-get-count-of-working-days-between-two-dates/m-p/775314#M274917 <HTML><HEAD></HEAD><BODY><P>there is already a built in function in qlikview which is networkdays to get the working days between two dates.</P></BODY></HTML> Wed, 19 Nov 2014 07:05:55 GMT https://community.qlik.com/t5/QlikView/how-to-get-count-of-working-days-between-two-dates/m-p/775314#M274917 maleksafa 2014-11-19T07:05:55Z Re: how to get count of working days between two dates https://community.qlik.com/t5/QlikView/how-to-get-count-of-working-days-between-two-dates/m-p/775315#M274918 <HTML><HEAD></HEAD><BODY><P>Hi, can this function be used during a script load?</P></BODY></HTML> Wed, 13 May 2015 10:45:02 GMT https://community.qlik.com/t5/QlikView/how-to-get-count-of-working-days-between-two-dates/m-p/775315#M274918 2015-05-13T10:45:02Z Re: how to get count of working days between two dates https://community.qlik.com/t5/QlikView/how-to-get-count-of-working-days-between-two-dates/m-p/775316#M274919 <HTML><HEAD></HEAD><BODY><P>It definitely can be used in the script as well <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Wed, 13 May 2015 10:47:58 GMT https://community.qlik.com/t5/QlikView/how-to-get-count-of-working-days-between-two-dates/m-p/775316#M274919 sunny_talwar 2015-05-13T10:47:58Z Re: how to get count of working days between two dates https://community.qlik.com/t5/QlikView/how-to-get-count-of-working-days-between-two-dates/m-p/1797257#M1211366 <P>this is a good function, but how can i add days that fall on weekends with it?</P> Tue, 06 Apr 2021 15:07:31 GMT https://community.qlik.com/t5/QlikView/how-to-get-count-of-working-days-between-two-dates/m-p/1797257#M1211366 Taraun 2021-04-06T15:07:31Z