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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.

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.