T
The Rook
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+holidays booked for the
employee in column A))
Hopefully that makes sense. Is it possible?
Thanks
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+holidays booked for the
employee in column A))
Hopefully that makes sense. Is it possible?
Thanks