I owe you a beer . . .
Many thanks !!

"Mike H" wrote in message
...
Hi,

That because your using the Workday function which returns a date a number
of workdays after the start date.

Excel is taking your date in A1 and adding 39740 workdays, format a2 as
general and you'll see why.

You should be using NETWORKDAYS(a1,a2) and getting an answer of 13

Mike

"Steve" wrote:

Mike:

Thanks very much.
Loaded the ATP . . . I get a number, but it's telling me there are 95,370
days from Oct-01-2008 to Oct-19-2008 . . . . hmmm

Any thoughts
Excel is 2003 on XP-Pro-SP3
Thanks again


"Mike H" wrote in message
...
Hi,

They're part of the ATP so
Tools|Addins and load the analysis toolpak.

Mike

"S Boak" wrote:

Hi Folks:

Thought this would be simple . . . .
Trying to get the number of work days in C1 from dates in A1 and B1

A1: First Day of month
B1: Last Day of month
C1:

=WORKDAY(A1,B1)
or
=NETWORKDAYS(A1,B1) both return #NAME?

Any help appreciated - Thanks
Steve