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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
khaycock
Creator
Creator

Work Week

Is there any way to exclude all Saturday's and Sunday's from my date to make it a Monday-Friday work week?

I have two date fields and I want to calculate the difference between them as a plus or minus working days

Planned Date - Actual Date AS Working Days

At the moment it works fine but will sum all days when I want just Monday-Friday to be calculated

Labels (1)
10 Replies
khaycock
Creator
Creator
Author

This works perfectly, thank you so much for all your help 🙂