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.

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

Tyro

"orquidea" wrote in message
...
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.

Thanks a lot Tyro

"Tyro" wrote:

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

Tyro

"orquidea" wrote in message
...
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.

You have to install the analysis toolpak.

Tools|Addins and check that addin.



orquidea wrote:

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.

--

Dave Peterson

Thanks

"Dave Peterson" wrote:

You have to install the analysis toolpak.

Tools|Addins and check that addin.



orquidea wrote:

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.

--

Dave Peterson

By reading the info in Helpnetworkdays you will find that you need the Analysis
ToolPak loaded.

ToolsAdd-inATP

Help is very handy in cases like this.


Gord Dibben MS Excel MVP


On Fri, 15 Feb 2008 11:17:00 -0800, orquidea
wrote:

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.