#1   Report Post  
sinbad
 
Posts: n/a
Default 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
  #2   Report Post  
aristotle
 
Posts: n/a
Default

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

  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NETWORKDAYS() not avaialbe after reopening Stan Excel Worksheet Functions 2 June 19th 05 04:53 PM
NETWORKDAYS function problem Arvi Laanemets Excel Worksheet Functions 5 April 19th 05 08:10 AM
Total hours with NETWORKDAYS Spencer Hutton Excel Worksheet Functions 2 February 16th 05 04:36 PM
Networkdays shows as #NAME even though I have the toolpack instal. mark Excel Discussion (Misc queries) 1 December 1st 04 09:13 PM
MS Excel Function - Networkdays Nilesh Inamdar Excel Worksheet Functions 3 November 26th 04 07:10 PM


All times are GMT +1. The time now is 02:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"