Annual leave without holidays

[tia.abdelkarim]

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

 

[Bob Phillips]

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)

 

[tia.abdelkarim]

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)











- Show quoted text -

Yes actually i am using network days but its not working

Total =NETWORKDAYS(B17,C17)
B= from
C=To

Holidays

B C
C52 New Year 1/1/2008
C53 St Maron's Day 9/2/2008
C54 Good Friday - -
C55 Labor Day 1/5/2008
C56 Atha's Day - -
C57 Fitr's Day - -
C58 MondayEaster - -
C59 Independence Day 22/11/2008
C60 Christmas 25/12/2008
C61 Virgin Mary - -

PLEASE ADVISE
TIA

 

[Bob Phillips]

=NETWORKDAYS(B17,C17,C52:C61)

--
---
HTH

Bob


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