topic Re: Get num of days between 2 dates in QlikView https://community.qlik.com/t5/QlikView/Get-num-of-days-between-2-dates/m-p/590210#M1118146 <HTML><HEAD></HEAD><BODY><P>Many thanks , but didnt get y u add 1 to each??</P></BODY></HTML> Sat, 15 Feb 2014 16:23:28 GMT 2014-02-15T16:23:28Z Get num of days between 2 dates https://community.qlik.com/t5/QlikView/Get-num-of-days-between-2-dates/m-p/590207#M1118143 <HTML><HEAD></HEAD><BODY><P>How can i get the number of days between two dates</P><P>without counting the weekend which are <STRONG style="text-decoration: underline;">Friday</STRONG> and <SPAN style="text-decoration: underline;"><STRONG>Saturday &gt;&gt;</STRONG></SPAN></P></BODY></HTML> Sat, 15 Feb 2014 11:39:14 GMT https://community.qlik.com/t5/QlikView/Get-num-of-days-between-2-dates/m-p/590207#M1118143 2014-02-15T11:39:14Z Re: Get num of days between 2 dates https://community.qlik.com/t5/QlikView/Get-num-of-days-between-2-dates/m-p/590208#M1118144 <HTML><HEAD></HEAD><BODY><P>You need to create a flag in script as</P><P>If(WeekDay(Date) = 4 or WeekDay(Date) = 5, 0 , 1) as Flag</P><P>and can count the no of working days as SUM(Flag)</P><P>Please check enclosed file which may help you.</P></BODY></HTML> Sat, 15 Feb 2014 12:06:40 GMT https://community.qlik.com/t5/QlikView/Get-num-of-days-between-2-dates/m-p/590208#M1118144 MK_QSL 2014-02-15T12:06:40Z Re: Get num of days between 2 dates https://community.qlik.com/t5/QlikView/Get-num-of-days-between-2-dates/m-p/590209#M1118145 <HTML><HEAD></HEAD><BODY><P>You can use the networkdays function: networkdays(DateA+1, DateB+1)</P></BODY></HTML> Sat, 15 Feb 2014 12:57:26 GMT https://community.qlik.com/t5/QlikView/Get-num-of-days-between-2-dates/m-p/590209#M1118145 Gysbert_Wassenaar 2014-02-15T12:57:26Z Re: Get num of days between 2 dates https://community.qlik.com/t5/QlikView/Get-num-of-days-between-2-dates/m-p/590210#M1118146 <HTML><HEAD></HEAD><BODY><P>Many thanks , but didnt get y u add 1 to each??</P></BODY></HTML> Sat, 15 Feb 2014 16:23:28 GMT https://community.qlik.com/t5/QlikView/Get-num-of-days-between-2-dates/m-p/590210#M1118146 2014-02-15T16:23:28Z Re: Get num of days between 2 dates https://community.qlik.com/t5/QlikView/Get-num-of-days-between-2-dates/m-p/590211#M1118147 <HTML><HEAD></HEAD><BODY><P>NetWorkDays(Start,End,Holidays) will give you total number of working days excluding Saturdays and Sundays.</P><P>i.e. Monday to Friday working days</P><P>Saturday and Sunday WeekEnds</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">By adding 1 to Start and End Date, we are forcing NetWorkDays to count this calculation by shifting one place.</SPAN></P><P>i.e. Sunday to Thursday working days</P><P>Friday and Saturday WeekEnds...</P><P></P><P>Hope this help.. </P></BODY></HTML> Sat, 15 Feb 2014 16:38:24 GMT https://community.qlik.com/t5/QlikView/Get-num-of-days-between-2-dates/m-p/590211#M1118147 MK_QSL 2014-02-15T16:38:24Z