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?