topic NetWorkingDay with Saturday Half Day in QlikView https://community.qlik.com/t5/QlikView/NetWorkingDay-with-Saturday-Half-Day/m-p/499445#M480727 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>We are working 5 and half day a week. (Saturday considered as a half day)</P><P>Can anyone provide script or expression to get NetWorkingDays?</P><P>Is there any other way to get the result without using NetWorkingDays?</P><P>Better if answer will be having an example...</P><P></P><P>Thanks</P></BODY></HTML> Fri, 08 Nov 2013 16:43:50 GMT MK_QSL 2013-11-08T16:43:50Z NetWorkingDay with Saturday Half Day https://community.qlik.com/t5/QlikView/NetWorkingDay-with-Saturday-Half-Day/m-p/499445#M480727 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>We are working 5 and half day a week. (Saturday considered as a half day)</P><P>Can anyone provide script or expression to get NetWorkingDays?</P><P>Is there any other way to get the result without using NetWorkingDays?</P><P>Better if answer will be having an example...</P><P></P><P>Thanks</P></BODY></HTML> Fri, 08 Nov 2013 16:43:50 GMT https://community.qlik.com/t5/QlikView/NetWorkingDay-with-Saturday-Half-Day/m-p/499445#M480727 MK_QSL 2013-11-08T16:43:50Z Re: NetWorkingDay with Saturday Half Day https://community.qlik.com/t5/QlikView/NetWorkingDay-with-Saturday-Half-Day/m-p/499446#M480728 <HTML><HEAD></HEAD><BODY><P>Maybe this:</P><P>networkdays(startdate,enddate) + (div(enddate-startdate,7) - (weekday(startdate)&gt;weekday(enddate))/2</P></BODY></HTML> Fri, 08 Nov 2013 17:09:23 GMT https://community.qlik.com/t5/QlikView/NetWorkingDay-with-Saturday-Half-Day/m-p/499446#M480728 Gysbert_Wassenaar 2013-11-08T17:09:23Z Re: NetWorkingDay with Saturday Half Day https://community.qlik.com/t5/QlikView/NetWorkingDay-with-Saturday-Half-Day/m-p/499447#M480729 <HTML><HEAD></HEAD><BODY><P>This expression giving error.</P></BODY></HTML> Sat, 09 Nov 2013 08:32:32 GMT https://community.qlik.com/t5/QlikView/NetWorkingDay-with-Saturday-Half-Day/m-p/499447#M480729 MK_QSL 2013-11-09T08:32:32Z Re: NetWorkingDay with Saturday Half Day https://community.qlik.com/t5/QlikView/NetWorkingDay-with-Saturday-Half-Day/m-p/499448#M480730 <HTML><HEAD></HEAD><BODY><P>Got the solution...</P><P></P><P>=NetWorkDays(vStartDate,vEndDate)+CEIL(SUM(((WEEKDAY(vStartDate-7)+vEndDate-vStartDate)/7)))/2</P></BODY></HTML> Sat, 09 Nov 2013 09:48:37 GMT https://community.qlik.com/t5/QlikView/NetWorkingDay-with-Saturday-Half-Day/m-p/499448#M480730 MK_QSL 2013-11-09T09:48:37Z