Hi

I am working as an H.r and i am looking for a formula concerning the
annual leave

I have already found a formula that gives the total of the days
allowed without the weekends

But i do need to calculate the days taken excluding the weekends and
the holidays

A: starting date
B: Total of Days allowed
C: New Year 31/12/2008
D: Ester 24/3/2008
Etc

Please advise