I can think of only a few possible problems. If the ToolPak was not
installed when you typed in your formula and then you installed it, it might
need to be recalculated.

Is it possible that the date is in there as text, with maybe a leading or
trailing blank? Other than that I haven't a clue.

Art

"jsc3489" wrote:

I have the Analysis ToolPak installed and this WAS working before.

In cell B6 I have =WORKDAY(B4,G7)
In cell B4 I have 11/09/2005
In cell G7 I have 105

B6's result is #NAME?

What gives?
--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!