J
JellyB
Well I ended up using the following formula...
=IF(OR($I5="",$J5=""),"",NETWORKDAYS
($I5,$J5,$B$32:$B$41))
I5 is the start date of holiday, J5 the end date, B32:B41
are holidays, now what I have come accross is part-time
staff who work set days. Obviously the days that they do
not work are not deducted from their holidays so
basically what I think I need is to incorporate a VLOOKUP
so that when I create the employee's record I enter the
days they work and those will be excluded from the
NETWORKDAYS as they would for bank holidays.
Does this mean that if an employee works only Monday and
Tuesday for example, I will have to look on the calender
and individually type in all the wednesdays, thursdays,
and fridays that will have to be excluded from the
calculation or is there a quickfix.
Thanks
=IF(OR($I5="",$J5=""),"",NETWORKDAYS
($I5,$J5,$B$32:$B$41))
I5 is the start date of holiday, J5 the end date, B32:B41
are holidays, now what I have come accross is part-time
staff who work set days. Obviously the days that they do
not work are not deducted from their holidays so
basically what I think I need is to incorporate a VLOOKUP
so that when I create the employee's record I enter the
days they work and those will be excluded from the
NETWORKDAYS as they would for bank holidays.
Does this mean that if an employee works only Monday and
Tuesday for example, I will have to look on the calender
and individually type in all the wednesdays, thursdays,
and fridays that will have to be excluded from the
calculation or is there a quickfix.
Thanks