Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have been trying to use networkdays funtion. When I put in the holiday
dates it does not work with every date I put in. Example: putting in 2/6/2009 start date putting in 12/25/2009 end date putting in 2/14/2009 Holiday When I put in the exclusion date (Holiday ) : 2/7/2009 does not work 2/8/2009 does not work 2/9/2009 works 2/10/2009 works 2/11/2009 works 2/12/2009 works 2/13/2009 works 2/14/2009 does not work 2/15/2009 does not work 2/16/2009 does work I would rather not go through all the dates to find out which ones work and which ones do not. I'm using this funtion to make a countdown to Christmas with excluding weekends and holidays. I re-installed office and the problem still exists Has anyone else had this problem? Does anyone have a explanation and fix on whats happening. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup funtion is not working properly? | Excel Worksheet Functions | |||
networkdays and holidays | Excel Worksheet Functions | |||
NETWORKDAYS: using correct funtion? | Excel Worksheet Functions | |||
Removing holidays and weekends , networkdays | Excel Discussion (Misc queries) | |||
Removing holidays and weekends , networkdays | Excel Discussion (Misc queries) |