Annual leave without holidays
=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
|