networkdays function help

[Guest]

I'm trying to use the networkdays function. I see on another post that
something has to be installed? I've tried using the help function for
networkdays and it doesn't tell me anywhere that something needs to be
installed. Please help?

 

[Chip Pearson]

The NETWORKDAYS function is part of the Analysis Tool Pak add-in.
This add-in must be installed to use NETWORKDAYS. If it not
installed you'll get a #NAME error. To install the ATP, go to the
Tools menu, choose Add-Ins, and ensure that "Analysis ToolPak" is
checked.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Peo Sjoblom]

I am sure it does, in my excel 200 this it what it says in help

"If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
by using the Add-Ins command on the Tools menu."

then you can click on how and trhis comes up

"Install and use the Analysis ToolPak
Before using an analysis tool, you must arrange the data you want to analyze
in columns or rows on your worksheet. This is your input range.

If the Data Analysis command is not on the Tools menu, you need to install
the Analysis ToolPak in Microsoft Excel.

To install the Analysis ToolPak
On the Tools menu, click Add-Ins.
If Analysis ToolPak is not listed in the Add-Ins dialog box, click Browse
and locate the drive, folder name, and file name for the Analysis ToolPak
add-in, Analys32.xll - usually located in the Microsoft
Office\Office\Library\Analysis folder - or run the Setup program if it isn't
installed.

Select the Analysis ToolPak check box. "

To add to that the line "or run the setup program if it isn't installed"
that means you would need the CD with office/excel

 

[Guest]

Thank you very much.
This helped me resolve my issues.
However, I do have a new problem.
Not all my users have this function "turned on".
Is there any way to imbed this function into the sheet so they don't
necessarily have to turn it on?

thanks,

Debbie