My question is more complicated:
Introduction: In my country if we have national holiday (like the day of independence of USA – 4th of July) in the middle of the week, we also take holiday’s days between the national holiday and the weekend days, and in other week we must work in Saturday (like compensation of this working day in which we were on holiday).
OK, I have 3 weeks:
Week 1: I have to work on Saturday (like compensation of this working day in which we will be on holiday). So, in the week 1 I have 6 working days.
Week 2: On Thursday I have a national holiday. Friday is holiday’s day, too (because it is the day between the national holiday and the weekend days). Saturday and Sunday are general holidays. So, in the week 2 I have 3 working days.
Week 3 is regular – 5 working days.
If I use the WORKDAY.INTL function It will calculate working days but without calculating of this working Saturday: =WORKDAY.INTL(start_date; days;[weekend];[holydays])
For [weekend] I have different possibilities (from 1 till 17) how will be the regular weekend for whole period of the calculation. But I have regular weekend plan with exceptions.
Is there any function in Excel to calculate this: If date X is between dates Y and Z, sum. 1 day (date X) with the result of the WORKDAY function?
For the example: working days in the interval from Tuesday of week 1 till Wednesday of week 3 is the result of WORKDAY function plus 1, because the Saturday of week 1 is working day, too.
Is there any function for this calculation?