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

Announcements
Search may be unavailable 11:30 PM on Aug 24 to 1:30 AM on Aug 25. Thank you for your patience.
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 (2)
10 Replies
khaycock
Creator
Creator
Author

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