holidays does not work properly in networkdays funtion.

[GAW]

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.

 

[Shane Devenshire]

Hi,

The dates that you say are not working are Weekends! The Networkdays
function excludes those by definition, but not twice.

 

[Fred Smith]

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.

 

[JE McGimpsey]

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.

 

[GAW]

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