Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
Thanks for you help. I will check it