Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

poppypearce
New Contributor III

How to Calculate Difference Between 2 Dates, Excluding Holidays and Sunday in the Same Table.

Hi,

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.

2 Replies
MVP
MVP

Re: How to Calculate Difference Between 2 Dates, Excluding Holidays and Sunday in the Same Table.

poppypearce
New Contributor III

Re: How to Calculate Difference Between 2 Dates, Excluding Holidays and Sunday in the Same Table.

Thanks for your suggestion Tresesco.

but using GetWorkDays function i will get working days including saturday, but how to exclude Holidays in between 2 dates while calculating difference. please suggest.