topic Re: Saturday sunday & Holiday ommision in QlikView https://community.qlik.com/t5/QlikView/Saturday-sunday-Holiday-ommision/m-p/753411#M268484 <HTML><HEAD></HEAD><BODY><P>use NetworkDays.</P><P></P><P>This will allow you to create the number of Monday to Friday days in your values together with a list of holiday dates at the end that will be excluded.</P><P></P><P>Hope this helps</P></BODY></HTML> Thu, 19 Mar 2015 16:03:10 GMT Roop 2015-03-19T16:03:10Z Saturday sunday & Holiday ommision https://community.qlik.com/t5/QlikView/Saturday-sunday-Holiday-ommision/m-p/753410#M268483 <HTML><HEAD></HEAD><BODY><P><BR /></P><P></P><P>I want to excude saturday , sunday &amp; Holiday from date interval-</P><P></P><P></P><P></P><P>Interval</P><P></P><P></P><P><SPAN style="color: #000000; font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Resolved</SPAN><SPAN style="color: #000000; font-size: 8pt;">-</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Requested Date]</SPAN><SPAN style="color: #000000; font-size: 8pt;">,'d hhmm:ss') </SPAN></P><P> </P><P><SPAN style="color: #000000; font-size: 8pt;">Please help</SPAN></P><P></P></BODY></HTML> Thu, 19 Mar 2015 15:59:59 GMT https://community.qlik.com/t5/QlikView/Saturday-sunday-Holiday-ommision/m-p/753410#M268483 Anonymous 2015-03-19T15:59:59Z Re: Saturday sunday & Holiday ommision https://community.qlik.com/t5/QlikView/Saturday-sunday-Holiday-ommision/m-p/753411#M268484 <HTML><HEAD></HEAD><BODY><P>use NetworkDays.</P><P></P><P>This will allow you to create the number of Monday to Friday days in your values together with a list of holiday dates at the end that will be excluded.</P><P></P><P>Hope this helps</P></BODY></HTML> Thu, 19 Mar 2015 16:03:10 GMT https://community.qlik.com/t5/QlikView/Saturday-sunday-Holiday-ommision/m-p/753411#M268484 Roop 2015-03-19T16:03:10Z Re: Saturday sunday & Holiday ommision https://community.qlik.com/t5/QlikView/Saturday-sunday-Holiday-ommision/m-p/753412#M268485 <HTML><HEAD></HEAD><BODY><P>networkdays( start_date, end_date {, holiday} )</P><P>Returns the number of working days (Monday-Friday) between and</P><P>including start_date and end_date taking into account any optionally</P><P>listed holidays. All parameters should be valid dates or timestamps.</P><P>Example:</P><P>networkdays ('2007-02-19', '2007-03-01') returns 9</P><P>networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-</P><P>26') returns 8</P></BODY></HTML> Thu, 19 Mar 2015 16:04:00 GMT https://community.qlik.com/t5/QlikView/Saturday-sunday-Holiday-ommision/m-p/753412#M268485 buzzy996 2015-03-19T16:04:00Z