LOL thanks for feeding back!

--JP

On Aug 6, 4:50*pm, Connie Martin
wrote:
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?