U
undrline via OfficeKB.com
There are 4 calendar days between 10-24-2005 and 10-28-2005. But,
NETWORKDAYS is returning 5 workdays. I made sure to format as date, and
find/replace the slashes, to make absolutely certain Excel recognizes each
cell as a date. What am I doing wrong?
Using the formula
=NETWORKDAYS(B3,H3,holidays!$A$2:$A$65535)
Where
B3 is 10/24/2005
H3 is 10/28/2005
and
holidays!$A$2:$A$65535 is currently
5/30/2005
7/4/2005
9/5/2005
11/24/2005
11/25/2005
12/23/2005
12/25/2005
12/26/2005
1/2/2006
5/29/2006
7/4/2006
9/4/2006
11/23/2006
11/24/2006
12/25/2006
12/26/2006
Thanks in advance for your help.
NETWORKDAYS is returning 5 workdays. I made sure to format as date, and
find/replace the slashes, to make absolutely certain Excel recognizes each
cell as a date. What am I doing wrong?
Using the formula
=NETWORKDAYS(B3,H3,holidays!$A$2:$A$65535)
Where
B3 is 10/24/2005
H3 is 10/28/2005
and
holidays!$A$2:$A$65535 is currently
5/30/2005
7/4/2005
9/5/2005
11/24/2005
11/25/2005
12/23/2005
12/25/2005
12/26/2005
1/2/2006
5/29/2006
7/4/2006
9/4/2006
11/23/2006
11/24/2006
12/25/2006
12/26/2006
Thanks in advance for your help.