Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
HI
I am trying to count the total of leave taken without the holidays and the weekends i have used the NETWORKDAYS but i dont know what is the formula in order to have a total of vacation taken excluding weekends and holidays so this is the table that i have 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 PLEASE ADVISE TIA |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
NETWORKDAYS and excluding vacation/PTO time used | Excel Discussion (Misc queries) | |||
Workday With Weekends Excluding Holidays | Excel Worksheet Functions | |||
fill a series of dates excluding holidays | Excel Worksheet Functions | |||
Formula - Excluding weekends & holidays | Excel Worksheet Functions |