This is so silly...

[Guest]

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?

 

[Guest]

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

 

[Chip Pearson]

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

 

[Guest]

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

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

Temporary flake?