I am assuming that you are using NETWORKDAYS,

Create a list of holidays, and extend the formula to

=NETWORKDAYS(start_date,end_date,holidays)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
...
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