ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   NETWORKDAYS (https://www.excelbanter.com/excel-worksheet-functions/35989-networkdays.html)

sinbad

NETWORKDAYS
 
I am trying to use the networkdays function but I get a #NAME error!
I have loaded analysis function but it still does not work

Regards Steve

aristotle

That error is typical of not having analysis-toolpak isntalled. There are
two very similar ones to install, analysis toolpak & analysis toolpak VBA.
Check that you have the right one installed. Tools - Addins. If not then
I'm stumped, works for me...

"sinbad" wrote:

I am trying to use the networkdays function but I get a #NAME error!
I have loaded analysis function but it still does not work

Regards Steve


Bob Phillips

You are not trying to use a non-defined range name within the formula
perchance?

--
HTH

Bob Phillips

"sinbad" wrote in message
...
I am trying to use the networkdays function but I get a #NAME error!
I have loaded analysis function but it still does not work

Regards Steve





All times are GMT +1. The time now is 04:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com