# Working days - specific case

January 29, 2013 at 07:39:35
Specs: Windows 7, 2 Dual 1,5 GHz/2GB

 Hi,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?

See More: Working days - specific case

#1
January 29, 2013 at 13:11:37

 HiHave you looked at the NETWORKDAYS.INTL function that can be applied to different periods?

#2
January 30, 2013 at 00:29:31

 Yes, I tried.Weekend period possibilities are the same like in WORKDAY function (only 1 choice for weekend plan for whole period). The NETWORKDAYS.INTL function is not for my case. I want know the date after date X plus 10 working days with considering of holydays, weekends and additional working days. How can I calculate is there in the calculating period additional working days and if “YES”, how can I added them in calculation?