Excel Functions

  • Thread starter Thread starter Allen Hart
  • Start date Start date
A

Allen Hart

I am running Office 2000. I finally needed the functions "workdays" and
""networkdays". They did not appear on my functions list although they were
in the help files. I went back to the original disks and saw that everything
had been set to run from the computer.

How do I get ALL the built in functions? Any suggestions would be greatly
appreciated.

AH
 
Allen,

The NETWORKDAYS and WORKDAYS functions are part of the Analysis
Tool Pak add-in. You need to go to the Tools menu, choose
Add-Ins, and select Analysis Tool Pak from the list. Put a check
next to this item. If you don't see this item in the list, you
need to rerun the Office/Excel setup program and indicate that
you want the ATP installed.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Hi Allen!

Use:

Tools > Addins
Check Analysis ToolPak

You'll need the installation discs with Office 2000 unless the ToolPak
has been used before.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top