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!

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!

Are you sure you have the Analysis Tool Pak, not Analysis Tool
Pak VBA, installed?


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


"jsc3489" wrote in message
...
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!

Even sillier, it started working again like 'magic'. Go figuP

I changed the number in G7 and it worked, changed it back, still working.

Temporary flake?
--
I reject your reality and substitute my own.

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