topic Re: Worksday in a date difference in QlikView https://community.qlik.com/t5/QlikView/Worksday-in-a-date-difference/m-p/438752#M163533 <HTML><HEAD></HEAD><BODY><P>Whiteline.</P><P></P><P>Thanks. It works fine.</P></BODY></HTML> Tue, 25 Sep 2012 14:17:48 GMT Anonymous 2012-09-25T14:17:48Z Worksday in a date difference https://community.qlik.com/t5/QlikView/Worksday-in-a-date-difference/m-p/438750#M163531 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P></P><P>I need to count the number of work days (no staurdays and sundays) in a difference of two dates. Please help with this expression.</P><P></P><P>In SQL...&nbsp;&nbsp; datediff('dw',date1,date2)</P><P></P><P>Thanks in advance.</P><P>André Rodrigues</P></BODY></HTML> Tue, 25 Sep 2012 13:00:00 GMT https://community.qlik.com/t5/QlikView/Worksday-in-a-date-difference/m-p/438750#M163531 Anonymous 2012-09-25T13:00:00Z Re: Worksday in a date difference https://community.qlik.com/t5/QlikView/Worksday-in-a-date-difference/m-p/438751#M163532 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>You could use&nbsp; function <SPAN class="Bold"><STRONG>networkdays</STRONG></SPAN>().</P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD><P class="syntax"><SPAN class="Bold"><STRONG>networkdays</STRONG> (</SPAN><SPAN class="Italic">start:date, end_date {, holiday}</SPAN><SPAN class="Bold">)</SPAN></P><P>Returns the number of working days (Monday-Friday) between and <SPAN style="text-decoration: underline;">including <SPAN class="Italic">start_date</SPAN> and <SPAN class="Italic">end_date</SPAN> taking</SPAN> into account any optionally listed <SPAN class="Italic">holidays</SPAN>. All parameters should be valid dates or timestamps.</P></TD></TR></TBODY></TABLE></BLOCKQUOTE><P>Or calculate it manually, it's not so hard.</P></BODY></HTML> Tue, 25 Sep 2012 13:22:47 GMT https://community.qlik.com/t5/QlikView/Worksday-in-a-date-difference/m-p/438751#M163532 whiteline 2012-09-25T13:22:47Z Re: Worksday in a date difference https://community.qlik.com/t5/QlikView/Worksday-in-a-date-difference/m-p/438752#M163533 <HTML><HEAD></HEAD><BODY><P>Whiteline.</P><P></P><P>Thanks. It works fine.</P></BODY></HTML> Tue, 25 Sep 2012 14:17:48 GMT https://community.qlik.com/t5/QlikView/Worksday-in-a-date-difference/m-p/438752#M163533 Anonymous 2012-09-25T14:17:48Z