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.

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.

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.

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.

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