Yes. Actually, the full path does show but I had the other workbook open and
that's why it wasn't showing. But if I open this workbook without opening
the other, then the path shows in the formula.

Thanks
Connie

"Peo Sjoblom" wrote:

It might be easier if you have the full path etc when you name the range
like


='C:\Documents and Settings\psjoblom\Desktop\[Canadian
Non-Workdays.xls]Sheet1'!$A$1:$A$10


then just use


=NETWORKDAYS(B2,F2,NonWorkDays2008)

Otherwise if the other workbook is closed try

=NETWORKDAYS(B2,F2,'C:\Documents and Settings\psjoblom\Desktop\Canadian
Non-Workdays.xls'!NonWorkDays2008)

if open try

=NETWORKDAYS(B2,F2,'Canadian Non-Workdays.xls'!NonWorkDays2008)


adapt to fit your own path and folders etc



--


Regards,


Peo Sjoblom

"Connie Martin" wrote in message
...
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?