Thread: NETWORKDAYS
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Connie Martin Connie Martin is offline
external usenet poster
 
Posts: 251
Default NETWORKDAYS

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?