Blot

Please do not use all caps. Hard to read and is considered "SHOUTING"

The Analysis ToolPak add-in has to be loaded through ToolsAdd-ins to prevent
the #NAME? error.

If you check out Help on WORKDAY function it will tell you that.


Gord Dibben MS Excel MVP

On Wed, 12 Jul 2006 15:31:01 -0700, BLOTTY
wrote:

I CREATED A WORKSHEET WHICH TAKES A GIVEN DATE, SUBTRACTS A NUMBER OF GIVEN
DAYS AND A STANDARD NUMBER OF DAYS TO OUTPUT AN EARLIER DATE (NOT INCLUDING
WEEKENDS) WHEN OTHERS TRY TO USE IT ON DIFFERENT PC'S, SOME GET A "#NAME?"
ERROR AND WHILE OTHERS IT WORKS FOR.

THE FORMULA I USED IS:

=WORKDAY(B4,-C4-3)
B4=01/01/07 (DATE FORMAT 3/14/01)
C4=1 (NUMBER FORMAT 0 DECIMAL PLACES)