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

Report •


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

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

Report •

#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?

Report •

#3
January 30, 2013 at 10:24:31

Unfortunately I don't have access to 2010 at the moment so I can't test this but I believe that what is needed is to break down your equation to separate time periods - one for the initial period that is different than the on-going periods. The result of the first one will be the starting date for the second one.

Having said that, I have to ask, is this worth the effort? The functions in excel require a certain degree of consistency which is not the case with your situation and how likely is it these circumstances will arise again?


Report •

Related Solutions


Ask Question