The "networkdays" function doesn't work even with helpfile example

D

DavidFromIdaho

my excel help identifies this function, but the actual use of it returns the
?name error.

Furthermore, it does give me the dialogue box for the function to help me
fill in the data, but doesn't show any valid value and errors on completion
of the dialogue box.
 
D

Dave Peterson

You excel help file also says that if you get that #name? error, then you'll
have to install the Analysis toolpak.

(Tools|Addins)

Depending on how excel was installed, you may need the distribution CD.
 
B

Biff

Furthermore, it does give me the dialogue box for the function to help me
fill in the data, but doesn't show any valid value and errors on completion
of the dialogue box.
Click to expand...

In that dialog box, click on "Help on this function". It'll tell you what
the problem is and how to fix it.

Biff
 
K

Ken Hudson

Hi David,
Have you installed the Analysis ToolPak?
Go to Tools > Add-Ins... and check the Analysis ToolPak box.
Cheers.
 
Top