Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
poppypearce
Creator
Creator

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.

Labels (1)
2 Replies
poppypearce
Creator
Creator
Author

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.