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