ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   The "networkdays" function doesn't work even with helpfile example (https://www.excelbanter.com/excel-discussion-misc-queries/111878-networkdays-function-doesnt-work-even-helpfile-example.html)

DavidFromIdaho

The "networkdays" function doesn't work even with helpfile example
 
my excel help identifies this function, but the actual use of it returns the
?name error.

Furthermore, it does give me the dialogue box for the function to help me
fill in the data, but doesn't show any valid value and errors on completion
of the dialogue box.


Dave Peterson

The "networkdays" function doesn't work even with helpfile example
 
You excel help file also says that if you get that #name? error, then you'll
have to install the Analysis toolpak.

(Tools|Addins)

Depending on how excel was installed, you may need the distribution CD.

DavidFromIdaho wrote:

my excel help identifies this function, but the actual use of it returns the
?name error.

Furthermore, it does give me the dialogue box for the function to help me
fill in the data, but doesn't show any valid value and errors on completion
of the dialogue box.


--

Dave Peterson

Biff

The "networkdays" function doesn't work even with helpfile example
 
Furthermore, it does give me the dialogue box for the function to help me
fill in the data, but doesn't show any valid value and errors on completion
of the dialogue box.


In that dialog box, click on "Help on this function". It'll tell you what
the problem is and how to fix it.

Biff

"DavidFromIdaho" wrote in message
...
my excel help identifies this function, but the actual use of it returns
the
?name error.

Furthermore, it does give me the dialogue box for the function to help me
fill in the data, but doesn't show any valid value and errors on
completion
of the dialogue box.




Ken Hudson

The "networkdays" function doesn't work even with helpfile example
 
Hi David,
Have you installed the Analysis ToolPak?
Go to Tools Add-Ins... and check the Analysis ToolPak box.
Cheers.
--
Ken Hudson


"DavidFromIdaho" wrote:

my excel help identifies this function, but the actual use of it returns the
?name error.

Furthermore, it does give me the dialogue box for the function to help me
fill in the data, but doesn't show any valid value and errors on completion
of the dialogue box.



All times are GMT +1. The time now is 01:53 AM.

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