holidays does not work properly in networkdays funtion.

  • Thread starter Thread starter GAW
  • Start date Start date
G

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.
 
Hi,

The dates that you say are not working are Weekends! The Networkdays
function excludes those by definition, but not twice.
 
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.
 
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.
 
Shane Devenshire said:
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
Click to expand...
 
Back
Top