Calculate Network days excluding Friday and Holidays

[mukesh19]

Hi All,

I want to calculate the net workdays between two dates excluding Friday (Since Friday is weekend) and Holidays.

Tried using networkdays(). It is considering Sat and Sun as weekend. Is there a way to change the weekend to Friday.

If anyone came across this scenario please help me out. 

Thanks in advance

-Mukesh 

[rwunderlich]

One approach would be to add all Fridays into your holiday list. 

-Rob

[mukesh19]

Hi Bob,

Thanks for the response. If we add Fridays to holidays list, then Saturday and Sunday will also be excluded. But Sat and Sun should be included in the calculation. Since Sat and Sun are working days

[mruehl]

There is a thread using interval() to solve this:

https://community.qlik.com/t5/QlikView-App-Dev/QLIKview-networkdays-ignore-weekend/m-p/85517

I didn't test it but it looks good for me.

[mukesh19]

@mruehl  that might work. But the problem is if we join source table with Holiday table that would result in cross join which will lead to performance issues 

[mruehl]

Maybe the last entry in this thread? You just have to declare all fridays as holidays nad put it in the variable.