Include non working days as well in the calculation
Please help me on the below script. I've used networkdays function to include only working days and used a variable for the holidays. However, now I want to include the non working days as well in my calculation.
Could anyone please help me to modify my script to get over this?
If you want to include non working days as well then networkdays function won't be useful. You can simply take a subtraction between two dates which will give you days difference and then you can use networkdays functions to exclude the holidays if you want. So overall logic will go like below
Above highlighted logic will give you no. of holidays between two dates. Note that this will not work if you have holidays falls on non working days as this function will already exclude them. If so then need to handle the calculation of holidays bit differently which I have covered in my below blog post