Formula driving me crazy

[Guest]

For the past two years I have been running metrics on a share drive with the
same simple formula to add up the number of days between two dates and take
out weekends =networkdays(2a,2b) and it works. Recently I got a replacement
laptop and a docking station. Now when I run my macros the column that
provides the answer gives me the "name?" error. So I plug the old desktop
back in and it works fine, plug the laptop in and error. It's the same files.
So I'm thinking maybe this thing doesn't have enough memory or there is
something I have to set up in excel in order for it to read this formula. Any
body got and ideas for this frustrated analyst?

 

[Pete_UK]

If you want to use the NETWORKDAYS function, you must install the
Analysis Tool Pack add-in.

Hope this helps.

Pete

 

[Peo Sjoblom]

Make sure you install ATP (Analysis ToolPak) on your laptop, keep the cd/dvd
handy and click
tools>add-ins and check Analysis ToolPak


--


Regards,


Peo Sjoblom

 

[Guest]

Networkdays function is required Analysis ToolPak Add-Ins

Tools > Add-Ins > select Analysis ToolPak > OK out

 

[Roger Govier]

Hi

It sounds as though the Analysis Toolpak isn't loaded on the Laptop.
Tolls>Addins>Analysis Toolpak> check the box

 

[David Biddulph]

If you're having problems with an Excel function, it's always worth looking
up that function in Excel help.

 

[Guest]

OUTSTANDING!! Why didn't I think of that.

 

[Guest]

OUTSTANDING!! Why didn't I think of that.

 

[Guest]

OUTSTANDING!! Why didn't I think of that.

 

[Pete_UK]

The fact that he received the #NAME error is a bit of a give-away !!

Pete

 

[David Biddulph]

Exactly, and if he'd looked it up in Help he would have found the answer.

 

[Pete_UK]

Still, he seems happy enough with the answer - though he's replying to
his own post <bg>

Pete