software

Hello,

I am using the quot;=YEARFRAC(A1,B1,1)quot; formula to calculate tenure, where a1 is
the hiredate and B1 is a cell containing the quot;=today()quot; formula.

The formula works fine on my PC, but when I send the file to someone else,
they get an error msg. in the cell where the result is supposed to show up.

Does this have anything to do with the fact that they're on a LAN, and I'm
not? I'm really curious.

Thanks!


Stilla,

The other user(s) may need to install the Analysis ToolPak. Is it the
#NAME? error msg?

If so, go to Toolsgt;Add-Ins. Select the box next to Analysis ToolPak.
Click OK. The Add-In will install.HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=514990AH HA! Thanks Steve! now I can stop wondering!

quot;SteveGquot; wrote:

gt;
gt; Stilla,
gt;
gt; The other user(s) may need to install the Analysis ToolPak. Is it the
gt; #NAME? error msg?
gt;
gt; If so, go to Toolsgt;Add-Ins. Select the box next to Analysis ToolPak.
gt; Click OK. The Add-In will install.
gt;
gt;
gt; HTH
gt;
gt; Steve
gt;
gt;
gt; --
gt; SteveG
gt; ------------------------------------------------------------------------
gt; SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
gt; View this thread: www.excelforum.com/showthread...hreadid=514990
gt;
gt;