topic (senddate - orderdate) -- without counting the weekends in QlikView https://community.qlik.com/t5/QlikView/senddate-orderdate-without-counting-the-weekends/m-p/202308#M60066 <HTML><HEAD></HEAD><BODY><P>Thx ... didn't know the function yet.</P></BODY></HTML> Wed, 06 Jan 2010 10:58:27 GMT Anonymous 2010-01-06T10:58:27Z (senddate - orderdate) -- without counting the weekends https://community.qlik.com/t5/QlikView/senddate-orderdate-without-counting-the-weekends/m-p/202306#M60064 <HTML><HEAD></HEAD><BODY><P>I'm looking for an expression to calculate the turnaround days for a repair without counting the weekend days.</P><P>I have two date fields <B>order date</B> and <B>send date</B>.</P><P>What I'm looking for is a sum of <B>send date</B> - <B>order date</B> ... seems easy but I don't want the weekends to be in the calculation</P><P></P><P>For example:</P><P>order date <B>11/11/2009</B><BR />send date <B>11/18/2009</B></P><P>The result should be <B>5</B> instead of <B>7</B></P><P></P><P>order date <B>9/8/2009</B><BR />send date <B>11/16/2009</B></P><P>The result should be <B>49</B> instead of <B>69</B></P><P></P><P>Anyone got suggestions??<B><BR /></B></P></BODY></HTML> Wed, 06 Jan 2010 10:35:45 GMT https://community.qlik.com/t5/QlikView/senddate-orderdate-without-counting-the-weekends/m-p/202306#M60064 Anonymous 2010-01-06T10:35:45Z (senddate - orderdate) -- without counting the weekends https://community.qlik.com/t5/QlikView/senddate-orderdate-without-counting-the-weekends/m-p/202307#M60065 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>look for NETWORKDAYS. I hope you are now a step closer to your solution.</P><P>Good luck!</P><P>Rainer</P><P></P></BODY></HTML> Wed, 06 Jan 2010 10:52:54 GMT https://community.qlik.com/t5/QlikView/senddate-orderdate-without-counting-the-weekends/m-p/202307#M60065 2010-01-06T10:52:54Z (senddate - orderdate) -- without counting the weekends https://community.qlik.com/t5/QlikView/senddate-orderdate-without-counting-the-weekends/m-p/202308#M60066 <HTML><HEAD></HEAD><BODY><P>Thx ... didn't know the function yet.</P></BODY></HTML> Wed, 06 Jan 2010 10:58:27 GMT https://community.qlik.com/t5/QlikView/senddate-orderdate-without-counting-the-weekends/m-p/202308#M60066 Anonymous 2010-01-06T10:58:27Z