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.