Calculate Networkdays with Saturday included in QlikView
Load | |
floor(((Date2 - Date1)+1)/7)*6 + mod((Date2 - Date1)+1,7) | |
+ if(Weekday(Date1) + mod((Date2 - Date1)+1,7) < 7, 0, -1) as Workingdays_6 | |
... |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment