Help is very helpful if you enter networkdays and read the directions.

Also if you enter #NAME? you will get assistance on potential causes of
that error. ATP being the topmost culprit.

But, like any other help function you need to know what you're looking for.

In your case, either of the two above would have done the trick.

Do not take this as a "stay out of here" message.

Please continue to post when you have problems.


Gord Dibben MS Excel MVP


On Mon, 11 Aug 2008 16:46:01 -0700, Connie Martin
wrote:

I've no idea what RTFM is. And I do check Help but Help isn't usually much
help, and a lot of people like me will tell you the same thing. I appreciate
very much those who do take the time to answer. Connie

"David Biddulph" wrote:

It's always worth remembering that Excel has its own Help function, which
can answer quite a large proportion of the questions asked here in the
newsgroup (including yours). Regulars in the group try not to get grumpy
and impatient, and try not to answer "RTFM", but it is worth trying Help
first before asking the group.
--
David Biddulph

"Connie Martin" wrote in message
...
No, it wasn't. Thank you so much! It works now. What would I do without
this online help???!! Thanks a million. Connie

"JP" wrote:

If you go to Tools Add-Ins is "Analysis ToolPak" checked off?

--JP


On Aug 6, 4:23 pm, Connie Martin
wrote:
Can anyone tell me what's wrong with this formula?
=NETWORKDAYS(B2,F2,'Canadian Non-Workdays.xls'!NonWorkDays2008)-1

I am getting #NAME? The name is indeed defined as NonWorkDays2008 and
it is
in another workbook called Canadian Non-Workdays.

I want the number of non-workdays between the date in B2 and the date
in F2.
Both cells are formatted as dates.

What is wrong?