topic Need Networkdays in QlikView https://community.qlik.com/t5/QlikView/Need-Networkdays/m-p/1052435#M353114 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P></P><P>I have Year and Month fields, I need to show total no of working days of Employee excluding Saturday &amp; Sunday for individual month.</P><P></P><P></P><P></P><P></P><P></P><P></P><P>Thanks</P></BODY></HTML> Fri, 08 Jan 2016 14:56:25 GMT 2016-01-08T14:56:25Z Need Networkdays https://community.qlik.com/t5/QlikView/Need-Networkdays/m-p/1052435#M353114 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P></P><P>I have Year and Month fields, I need to show total no of working days of Employee excluding Saturday &amp; Sunday for individual month.</P><P></P><P></P><P></P><P></P><P></P><P></P><P>Thanks</P></BODY></HTML> Fri, 08 Jan 2016 14:56:25 GMT https://community.qlik.com/t5/QlikView/Need-Networkdays/m-p/1052435#M353114 2016-01-08T14:56:25Z Re: Need Networkdays https://community.qlik.com/t5/QlikView/Need-Networkdays/m-p/1052436#M353115 <HTML><HEAD></HEAD><BODY><P>hi. have you tried using the networkdays function?</P><P></P><P>see this link for help on the function:</P><P><A href="http://www.learnqlickview.com/qlikview-functions-networkdays/" title="http://www.learnqlickview.com/qlikview-functions-networkdays/">http://www.learnqlickview.com/qlikview-functions-networkdays/</A></P></BODY></HTML> Fri, 08 Jan 2016 19:01:42 GMT https://community.qlik.com/t5/QlikView/Need-Networkdays/m-p/1052436#M353115 2016-01-08T19:01:42Z Re: Need Networkdays https://community.qlik.com/t5/QlikView/Need-Networkdays/m-p/1052437#M353116 <HTML><HEAD></HEAD><BODY><P>You can use the NetWorkDays for this: NetWorkDays( Date1, Date2). If you have no date field then you need to create dates for the start and end date of the month: NetWorkDays(MakeDate(Year,Month), MakeDate(Year,Month+1)-1)</P></BODY></HTML> Fri, 08 Jan 2016 19:03:11 GMT https://community.qlik.com/t5/QlikView/Need-Networkdays/m-p/1052437#M353116 Gysbert_Wassenaar 2016-01-08T19:03:11Z