Thread: NETWORKDAYS
View Single Post
  #4   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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.

.