| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
holidays does not work properly in networkdays funtion.
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
holidays does not work properly in networkdays funtion.
Hi,
The dates that you say are not working are Weekends! The Networkdays function excludes those by definition, but not twice. -- If this helps, please click the Yes button Cheers, Shane Devenshire "GAW" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
holidays does not work properly in networkdays funtion.
February 14th is a Saturday, so will automatically be excluded by
Networkdays. The function has worked for thousands of people, and it will work for you too. Regards, Fred. "GAW" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
holidays does not work properly in networkdays funtion.
What do you mean when you say "doesn't work".
A holiday of 2/7 doesn't affect the calculation since 2/7 is a Saturday, which is already excluded. As is 2/8. In article , GAW wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
holidays does not work properly in networkdays funtion.
"Shane Devenshire" wrote: Hi, The dates that you say are not working are Weekends! The Networkdays function excludes those by definition, but not twice. -- If this helps, please click the Yes button Cheers, Shane Devenshire "GAW" wrote: 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. Thanks for the help guys. I didn't realize that it did not count the weekends......again thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
