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 ,
"Loi" 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 ,
"Loi" 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 toolsadd-ins


Regards,

Peo Sjoblom



" 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 ,
"Loi" 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 ToolsAddins, 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 StartSettingsControl 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,
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 ,
"Loi" 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.
.