Not Found Function

B

Byron720

I'm trying to use the function NETWORKDAYS in my Excel sheet (Excel 2003) and
it's not in the functions list. I keep getting a #NAME? message.
 
J

JE McGimpsey

As explained in Help, for XL versions prior to XL07/08, it's part of the
Analysis Toolpak Add-in (Tools/Add-ins...)
 
D

Dave O

By any chance do you need to re-install the Analysis Toolpak? Or are
you at a machine you don't ordinarily use? From the menu click >Tools
Add-ins and check the box for Analysis Toolpak, then click OK. It may
Click to expand...
take a moment to install.

Dave O
Eschew obfuscation
 
M

Marcelo

networkdays needs the analysis toolPak.

go to menu tools - Add-ins and check the Analysis ToolPak add-in

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Byron720" escreveu:
 
B

Byron720

I checked the Add ins before. They're all checked but still it doesn't
recognize the function
 
Top