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?

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?

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?

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?

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.
--
David Biddulph

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

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

"David Biddulph" wrote:

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.
--
David Biddulph

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

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


On Mon, 11 Aug 2008 16:46:01 -0700, Connie Martin
wrote:

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

"David Biddulph" wrote:

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.
--
David Biddulph

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

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

(or something like that)

Connie Martin wrote:

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

"David Biddulph" wrote:

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.
--
David Biddulph

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






--

Dave Peterson

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?

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?