topic Re: AGE in QlikView https://community.qlik.com/t5/QlikView/AGE/m-p/1377718#M420418 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/2454">sunny</A>‌ any help please. Thanks</P></BODY></HTML> Mon, 02 Oct 2017 10:26:21 GMT master_student 2017-10-02T10:26:21Z AGE https://community.qlik.com/t5/QlikView/AGE/m-p/1377717#M420417 <HTML><HEAD></HEAD><BODY><P>Hello Guys,</P><P>I hope you're doing good <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I want to calculate the difference between two days without counting sundays and counting the saturdays, and also without counting the local holidays witch are :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="206"><TBODY><TR><TD align="right" class="xl63" height="20" width="73">01/05/2017</TD><TD class="xl64" style="border-left: none;" width="133">Fête du Travail</TD></TR></TBODY></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="206"><TBODY><TR><TD align="right" class="xl65" height="20" width="73">25/07/2017</TD><TD class="xl66" style="border-left: none;" width="133">Fête de la République</TD></TR></TBODY></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="206"><TBODY><TR><TD align="right" class="xl65" height="20" width="73">25/07/2017</TD><TD class="xl66" style="border-left: none;" width="133">Fête de la République</TD></TR></TBODY></TABLE><P></P><P>The format of dates are : 9/21/2017 8:17:50 AM</P><P>The expression for now is&nbsp; : NetWorkDays(ROW_ADDED_DTTM, ROW_LASTMANT_DTTM)</P><P>Thanks</P></BODY></HTML> Mon, 02 Oct 2017 09:02:01 GMT https://community.qlik.com/t5/QlikView/AGE/m-p/1377717#M420417 master_student 2017-10-02T09:02:01Z Re: AGE https://community.qlik.com/t5/QlikView/AGE/m-p/1377718#M420418 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/2454">sunny</A>‌ any help please. Thanks</P></BODY></HTML> Mon, 02 Oct 2017 10:26:21 GMT https://community.qlik.com/t5/QlikView/AGE/m-p/1377718#M420418 master_student 2017-10-02T10:26:21Z