For what it's worth, I tried your formula and got a similar error. But, when
I tried using a simpler formula with NETWORKDAYS, it worked just fine.

Why not try =NETWORKDAYS(E7,E8) or something similar. Make sure that E7 and
E8 contain valid dates. If the formula works, then at least you'll know it
isn't the addin that's messing things up.

Art

"Stan Brown" wrote in message
...
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.

Help!

--
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."