NETWORKDAYS

Hi,

I have a problem with the formular: NETWORKDAYS(C4,D4). It
says that this formular contains unrecognized text.


Column: C D E

Ex: DATE POSTED DATE FILLED DAYS OPEN
2/5/2004 0:00 2/9/2004 0:00 =NETWORKDAYS(C4,D4)

It shows #NAME error in the cell E4 which contains the
formular =NETWORKDAYS(C4,D4).

Please tell me how to fix it.



Thank you
Loi

NETWORKDAYS is a function in the Analysis Toolpak Add-in
(Tools/Add-ins..., check the appropriate checkbox), as explained in Help.

In article <[email protected]>,
"Loi" <[email protected]> wrote:

> Hi,
>
> I have a problem with the formular: NETWORKDAYS(C4,D4). It
> says that this formular contains unrecognized text.
>
>
> Column: C D E
>
> Ex: DATE POSTED DATE FILLED DAYS OPEN
> 2/5/2004 0:00 2/9/2004 0:00 =NETWORKDAYS(C4,D4)
>
> It shows #NAME error in the cell E4 which contains the
> formular =NETWORKDAYS(C4,D4).
>
> Please tell me how to fix it.

Hi,

I checked TOOLS/Add-ins..., I don't see the Analysis
Toolpak. Please show me how I can install it.

Thank you
Loi
>-----Original Message-----
>NETWORKDAYS is a function in the Analysis Toolpak Add-in
>(Tools/Add-ins..., check the appropriate checkbox), as
explained in Help.
>
>In article <[email protected]>,
> "Loi" <[email protected]> wrote:
>
>> Hi,
>>
>> I have a problem with the formular: NETWORKDAYS(C4,D4).
It
>> says that this formular contains unrecognized text.
>>
>>
>> Column: C D E
>>
>> Ex: DATE POSTED DATE FILLED DAYS OPEN
>> 2/5/2004 0:00 2/9/2004 0:00 =NETWORKDAYS
(C4,D4)
>>
>> It shows #NAME error in the cell E4 which contains the
>> formular =NETWORKDAYS(C4,D4).
>>
>> Please tell me how to fix it.
>.
>

You might have to plop in the office/excel cd and install it, then check it
under tools>add-ins


Regards,

Peo Sjoblom



"[email protected]" wrote:

> Hi,
>
> I checked TOOLS/Add-ins..., I don't see the Analysis
> Toolpak. Please show me how I can install it.
>
> Thank you
> Loi
> >-----Original Message-----
> >NETWORKDAYS is a function in the Analysis Toolpak Add-in
> >(Tools/Add-ins..., check the appropriate checkbox), as
> explained in Help.
> >
> >In article <[email protected]>,
> > "Loi" <[email protected]> wrote:
> >
> >> Hi,
> >>
> >> I have a problem with the formular: NETWORKDAYS(C4,D4).
> It
> >> says that this formular contains unrecognized text.
> >>
> >>
> >> Column: C D E
> >>
> >> Ex: DATE POSTED DATE FILLED DAYS OPEN
> >> 2/5/2004 0:00 2/9/2004 0:00 =NETWORKDAYS
> (C4,D4)
> >>
> >> It shows #NAME error in the cell E4 which contains the
> >> formular =NETWORKDAYS(C4,D4).
> >>
> >> Please tell me how to fix it.
> >.
> >
>

Loi

If Analysis Toolpak is not available in Tools>Addins, perhaps a "custom"
install was done rather than "typical".

You will have to install from CD.

Following is for Office 2002 under Windows XP. Your setup may vary.

Go to Start>Settings>Control Panel and Add/remove programs.

Have your CD handy.

Click on Office 2000 or whatever it is called.

Select "Change" and "Add or Remove Programs".

Browse through and select the add-in required. Follow the steps.

Gord Dibben Excel MVP

On Tue, 18 Jan 2005 09:15:16 -0800, <[email protected]>
wrote:

> Hi,
>
> I checked TOOLS/Add-ins..., I don't see the Analysis
>Toolpak. Please show me how I can install it.
>
>Thank you
>Loi
>>-----Original Message-----
>>NETWORKDAYS is a function in the Analysis Toolpak Add-in
>>(Tools/Add-ins..., check the appropriate checkbox), as
>explained in Help.
>>
>>In article <[email protected]>,
>> "Loi" <[email protected]> wrote:
>>
>>> Hi,
>>>
>>> I have a problem with the formular: NETWORKDAYS(C4,D4).
>It
>>> says that this formular contains unrecognized text.
>>>
>>>
>>> Column: C D E
>>>
>>> Ex: DATE POSTED DATE FILLED DAYS OPEN
>>> 2/5/2004 0:00 2/9/2004 0:00 =NETWORKDAYS
>(C4,D4)
>>>
>>> It shows #NAME error in the cell E4 which contains the
>>> formular =NETWORKDAYS(C4,D4).
>>>
>>> Please tell me how to fix it.
>>.
>>