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?