View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GAW GAW is offline
external usenet poster
 
Posts: 4
Default 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.