How to check the number of public holidays days found between 2 dates

[Anonymous]

Hi

I have 2 dates, date_In and date_Out. I also have a list of bank holidays appended in a list ('holiday1,holiday2,holiday3')

I would like to know if there is a way to calculate in the script how many public holidays there are between date_in and date_out.

Thanks

Hasnaa

[Anonymous]

The holidays are different for several countries, in this case operator. I even use date in the script but then networkdays does not work at all. It is not excluding holidays . please see image attached

[#3]

hmm, not sure if network days will work for you in that case, with a shifting third parameter like that. Think the only way to use it in your case, would be to loop through each of the operator codes in turn, rather than a full load, that should work for you.

[#4]

been quite busy, but the attached might help you, not been able to test it, so a bit of blind coding, so forgive the errors!

hope that helps

Joe

[Anonymous]

Thanks for you help. I will check it