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

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

On Mar 14, 5:59 pm, "Bob Phillips" wrote:
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- Hide quoted text -

- 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

=NETWORKDAYS(B17,C17,C52:C61)

--
---
HTH

Bob


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



wrote in message
...
On Mar 14, 5:59 pm, "Bob Phillips" wrote:
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- Hide quoted text -

- 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