Annual leave without holidays
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 |
Annual leave without holidays
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 |
Annual leave without holidays
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 |
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 |
All times are GMT +1. The time now is 07:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com