Hi

Networkdays includes the first and last days and gives a result of 5 ,
unlike subtracting the earlier date from the later date which returns
the interval between the dates, being 4.

24, 25, 26, 27, 28 of October 2005 being Monday to Friday gives the
result of 5 days

--
Regards

Roger Govier


"undrline via OfficeKB.com" <u28594@uwe wrote in message
news:6c17bf23f9e0d@uwe...
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.

--
Message posted via http://www.officekb.com