WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE
Apologies accepted and explanation is reasonable and understandable with a
newcomer.
Welcome to the world of news groups, especially the Excel news groups.
Gord
On Wed, 12 Jul 2006 16:31:02 -0700, BLOTTY
wrote:
Sorry about the caps. This was my first day using this avenue for help.
Thanks again.
"Gord Dibben" wrote:
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)
Gord Dibben MS Excel MVP
|