topic How to Calculate Difference Between 2 Dates, Excluding Holidays and Sunday in the Same Table. in QlikView https://community.qlik.com/t5/QlikView/How-to-Calculate-Difference-Between-2-Dates-Excluding-Holidays/m-p/1297484#M616661 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I Need to Calculate Difference Between Date of Departure and Date of Arrival Excluding Holidays and Sunday in the Same Table. Including Saturday. Please Suggest.</P></BODY></HTML> Sun, 07 May 2017 16:04:41 GMT poppypearce 2017-05-07T16:04:41Z How to Calculate Difference Between 2 Dates, Excluding Holidays and Sunday in the Same Table. https://community.qlik.com/t5/QlikView/How-to-Calculate-Difference-Between-2-Dates-Excluding-Holidays/m-p/1297484#M616661 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I Need to Calculate Difference Between Date of Departure and Date of Arrival Excluding Holidays and Sunday in the Same Table. Including Saturday. Please Suggest.</P></BODY></HTML> Sun, 07 May 2017 16:04:41 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-Difference-Between-2-Dates-Excluding-Holidays/m-p/1297484#M616661 poppypearce 2017-05-07T16:04:41Z Re: How to Calculate Difference Between 2 Dates, Excluding Holidays and Sunday in the Same Table. https://community.qlik.com/t5/QlikView/How-to-Calculate-Difference-Between-2-Dates-Excluding-Holidays/m-p/1297485#M616662 <HTML><HEAD></HEAD><BODY><P>Check it here : <A href="https://community.qlik.com/docs/DOC-16251">Master Calendar with Working days &amp;amp; Holidays Flag</A></P><P><A href="https://community.qlik.com/message/1249580">Re: Networkdays with saturday</A></P></BODY></HTML> Mon, 08 May 2017 07:26:30 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-Difference-Between-2-Dates-Excluding-Holidays/m-p/1297485#M616662 tresB 2017-05-08T07:26:30Z Re: How to Calculate Difference Between 2 Dates, Excluding Holidays and Sunday in the Same Table. https://community.qlik.com/t5/QlikView/How-to-Calculate-Difference-Between-2-Dates-Excluding-Holidays/m-p/1297486#M616663 <HTML><HEAD></HEAD><BODY><P>Thanks for your suggestion Tresesco.</P><P>but using <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">GetWorkDays function i will get working days including saturday, but how to exclude Holidays in between 2 dates while calculating difference. please suggest.</SPAN></P></BODY></HTML> Wed, 10 May 2017 05:13:38 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-Difference-Between-2-Dates-Excluding-Holidays/m-p/1297486#M616663 poppypearce 2017-05-10T05:13:38Z