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?