Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Annual leave | Excel Discussion (Misc queries) | |||
Dates, Holidays and maternity leave... | Excel Discussion (Misc queries) | |||
Annual Leave Planner | Excel Discussion (Misc queries) | |||
Annual Leave | Excel Discussion (Misc queries) | |||
Tracking annual leave | New Users to Excel |