NETWORKDAYS

[Loi]

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

 

[JE McGimpsey]

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

 

[Guest]

Hi,

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

Thank you
Loi

 

[Peo Sjoblom]

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


Regards,

Peo Sjoblom

 

[Gord Dibben]

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