NETWORKDAYS

[Connie Martin]

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?

 

[JP]

If you go to Tools> Add-Ins is "Analysis ToolPak" checked off?

--JP

 

[Connie Martin]

No, it wasn't. Thank you so much! It works now. What would I do without
this online help???!! Thanks a million. Connie

 

[Peo Sjoblom]

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

 

[JP]

LOL thanks for feeding back!

--JP

No, it wasn't.  Thank you so much!  It works now.  What would I do without
this online help???!!  Thanks a million.   Connie

 

[Connie Martin]

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

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

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?

 

[David Biddulph]

It's always worth remembering that Excel has its own Help function, which
can answer quite a large proportion of the questions asked here in the
newsgroup (including yours). Regulars in the group try not to get grumpy
and impatient, and try not to answer "RTFM", but it is worth trying Help
first before asking the group.

 

[Connie Martin]

I've no idea what RTFM is. And I do check Help but Help isn't usually much
help, and a lot of people like me will tell you the same thing. I appreciate
very much those who do take the time to answer. Connie

 

[Gord Dibben]

Help is very helpful if you enter networkdays and read the directions.

Also if you enter #NAME? you will get assistance on potential causes of
that error. ATP being the topmost culprit.

But, like any other help function you need to know what you're looking for.

In your case, either of the two above would have done the trick.

Do not take this as a "stay out of here" message.

Please continue to post when you have problems.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

RTFM is an acronym for "Read The Flippin' Manual"

(or something like that)