Annual Leave Summary
Advise what? All you have told is what you are doing (which is inconsistent
btw, see the holiday range and the formula). I presume this doesn't work,
but in what way, what should it do, etc. Is there more data than this, more
info required.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Tia" wrote in message
...
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
|