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
|