WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE
No, don't do that. Just the Analysis Toolpak will be fine in 90% of
situations.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"BLOTTY" wrote in message
...
Thanks fellas, that was it. Should I tell my IT department to turn on all
these add-ins or could this cause problems???
"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)
|