NETWORKDAYS formula

[orquidea]

Hi:

I have a spreadsheet with the NETWORKDAYS formula on it. It does work
perfectly on my computer, but when I use the exactly same file in other
computer it does not work. The answer I get is #NAME?. If I do the
deduction of the same 2 dates just with the simple formula C2-A2 I get the
right answer. I need to deduct 2 dates not considering the weekends that's
why I use NETWORKDAYS.

Does anyone know if there is any special setting I have to do on a computer
in order to have NETWORKDAYS formula working?

Thanks
Orquidea.

 

[Tyro]

In versions prior to Excel 2007, you have to have the Analysis Toolpak
add-in installed.

Tyro

 

[Dave Peterson]

You have to install the analysis toolpak.

Tools|Addins and check that addin.

 

[orquidea]

Thanks a lot Tyro

In versions prior to Excel 2007, you have to have the Analysis Toolpak
add-in installed.

Tyro

 

[orquidea]

Thanks

You have to install the analysis toolpak.

Tools|Addins and check that addin.

 

[Gord Dibben]

By reading the info in Help>networkdays you will find that you need the Analysis
ToolPak loaded.

Tools>Add-in>ATP

Help is very handy in cases like this.


Gord Dibben MS Excel MVP