On Tue, 31 May 2005 15:28:40 -0400, Stan Brown
wrote:

This is a real head-scratcher in Excel 2003 under Win XP Pro SP2.

My formula is
=MIN(ProfWeeks,MAX(0,NETWORKDAYS(E7,TODAY())))
and it gives #NAME?. I clicked on the little ! icon and chose Show
Calculation Steps; it confirms that NETWORKDAYS is the problem.

Yes, ATP is checked in "Tools - Addins".

http://support.microsoft.com/default...b;en-us;291058 gives
advice, which I followed, to force a recalculate. That didn't help
either.

I don't know if this is true for earlier versions, but in Excel 2003
there are TWO check boxes: "Analysis Toolpak" and "Analysis Toolpak
VBA".

Excel 2003 help and Microsoft's site mention only the first, and I
had it checked, but I didn't have "Data Analysis" in the Tools menu,
and I didn't have functions like NETWORKDAYS().

Today, on a whim :-) I also checked "Analysis Toolpak VBA", and now
I have Tools - Data Analysis and a quick test of NETWORKDAYS worked
fine.

Those who were trying to help might have earlier versions of Excel
with only the one checkbox, or might have assumed when I checked
"Analysis Toolpak" that I checked both. But I'm pretty
literal-minded and since I wasn't told to check the VBA one I
didn't.

Anyway, I thought Peo and others might appreciate knowing that the
mystery is cleared up --and again, I'm grateful for the time you
spent with my problem.


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"I feel a wave of morning sickness coming on, and I want to
be standing on your mother's grave when it hits."