NETWORKDAYS
 

I am currently using NETWORKDAYS to calculate the number of working days
between 2 dates taking into account any static holidays the compmany has put
in place. The current formula is

+NETWORKDAYS(F$1,F$2,Calander!$L$2:$M$65536) L2:M65536 contains holidays
that all the company have to take.

Column A contains employee names, column A on worksheet 'Holidays' also
contains employee names, then columns A onwards contains the dates which that
employee has booked as holidays.

What I am trying to do is something like the following:
+NETWORKDAYS(F$1,F$2,(Calander!$L$2:$M$65536+holid ays booked for the
employee in column A))

Hopefully that makes sense. Is it possible?

Thanks

NETWORKDAYS
 

=NETWORKDAYS(start_date,end_date,static_holidays:e mployee_holidays)


"The Rook" wrote:

I am currently using NETWORKDAYS to calculate the number of working days
between 2 dates taking into account any static holidays the compmany has put
in place. The current formula is

+NETWORKDAYS(F$1,F$2,Calander!$L$2:$M$65536) L2:M65536 contains holidays
that all the company have to take.

Column A contains employee names, column A on worksheet 'Holidays' also
contains employee names, then columns A onwards contains the dates which that
employee has booked as holidays.

What I am trying to do is something like the following:
+NETWORKDAYS(F$1,F$2,(Calander!$L$2:$M$65536+holid ays booked for the
employee in column A))

Hopefully that makes sense. Is it possible?

Thanks

NETWORKDAYS
 

1.The static holidays are on a different worksheet to the employee's holidays
2.how do I get it to lookup the employee in column A on the employee holiday
sheet?

"Teethless mama" wrote:

=NETWORKDAYS(start_date,end_date,static_holidays:e mployee_holidays)


"The Rook" wrote:

I am currently using NETWORKDAYS to calculate the number of working days
between 2 dates taking into account any static holidays the compmany has put
in place. The current formula is

+NETWORKDAYS(F$1,F$2,Calander!$L$2:$M$65536) L2:M65536 contains holidays
that all the company have to take.

Column A contains employee names, column A on worksheet 'Holidays' also
contains employee names, then columns A onwards contains the dates which that
employee has booked as holidays.

What I am trying to do is something like the following:
+NETWORKDAYS(F$1,F$2,(Calander!$L$2:$M$65536+holid ays booked for the
employee in column A))

Hopefully that makes sense. Is it possible?

Thanks

NETWORKDAYS
 

One simple way is to insert a column at the place you want on the employee
holiday sheet and count the no of days she took an holiday and subtract that
from your networkdays calculation.

Keeping things simple saves time and gives you components which you can reuse.