J
junglejinge
At present I am using the following formula to calculate holiday
taken...
=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 publi
holidays, now what I have come accross is part-time staff who work se
days. Obviously the days that they do not work are not deducted fro
their holidays so basically what I think I need is to incorporate
VLOOKUP so that when I create the employee's record I enter the day
they work and those will be excluded from the NETWORKDAYS as they woul
for bank holidays.
Does this mean that if an employee works only Monday and Tuesday fo
example, I will have to look on the calender and individually type i
all the wednesdays, thursdays, and fridays that will have to b
excluded from the calculation or is there a quickfix.
Thank
taken...
=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 publi
holidays, now what I have come accross is part-time staff who work se
days. Obviously the days that they do not work are not deducted fro
their holidays so basically what I think I need is to incorporate
VLOOKUP so that when I create the employee's record I enter the day
they work and those will be excluded from the NETWORKDAYS as they woul
for bank holidays.
Does this mean that if an employee works only Monday and Tuesday fo
example, I will have to look on the calender and individually type i
all the wednesdays, thursdays, and fridays that will have to b
excluded from the calculation or is there a quickfix.
Thank