View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tia[_3_] Tia[_3_] is offline
external usenet poster
 
Posts: 79
Default Annual Leave Summary

Hi,

I am trying to find a formula that allows me to know how many days an
employee took as a vactaion on each month a summary sheet for each
employee
In order to find the number of days taken i have use the following :


B22=From (date)
C22= To Date
D22= Total Taken
C22:C44 =Official Holidays
=NETWORKDAYS(B22,C22,C44:C53)


Please advise
Tia