software

I have a the formula quot;YEARFRACquot; on one of my spreadsheets to calculate the
length of time between two dates. When I look at the spreadsheet on my
computer, the formula displays the correct answer, and also does so on most
of my co-workers computers. However, for on co-worker, she gets the error
quot;#NAME.quot; I think it is a setting on her computer, but cannot find one. Any
ideas, or am I missing the setting?

Thanks!
Josh

quot;JDubquot; gt; wrote in message
...
gt;I have a the formula quot;YEARFRACquot; on one of my spreadsheets to calculate the
gt; length of time between two dates. When I look at the spreadsheet on my
gt; computer, the formula displays the correct answer, and also does so on
gt; most
gt; of my co-workers computers. However, for on co-worker, she gets the error
gt; quot;#NAME.quot; I think it is a setting on her computer, but cannot find one.
gt; Any
gt; ideas, or am I missing the setting?

Analysis ToolPak:
office.microsoft.com/en-gb/as...093441033.aspx
--
David Biddulph
Another way would be to use your Excel help looking up YEARFRAC
whether in HELP or on the referred to web page (they are the same content),
you should expand the presentation with the quot;Show Allquot; link in the upper right
of the help page.

quot;David Biddulphquot; gt; wrote in message news
gt; quot;JDubquot; gt; wrote in message
gt; ...
gt; gt;I have a the formula quot;YEARFRACquot; on one of my spreadsheets to calculate the
gt; gt; length of time between two dates. When I look at the spreadsheet on my
gt; gt; computer, the formula displays the correct answer, and also does so on
gt; gt; most
gt; gt; of my co-workers computers. However, for on co-worker, she gets the error
gt; gt; quot;#NAME.quot; I think it is a setting on her computer, but cannot find one.
gt; gt; Any
gt; gt; ideas, or am I missing the setting?
gt;
gt; Analysis ToolPak:
gt; office.microsoft.com/en-gb/as...093441033.aspx
gt; --
gt; David Biddulph
gt;
gt;
Many thanks!

quot;David McRitchiequot; wrote:

gt; Another way would be to use your Excel help looking up YEARFRAC
gt; whether in HELP or on the referred to web page (they are the same content),
gt; you should expand the presentation with the quot;Show Allquot; link in the upper right
gt; of the help page.
gt;
gt; quot;David Biddulphquot; gt; wrote in message news
gt; gt; quot;JDubquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I have a the formula quot;YEARFRACquot; on one of my spreadsheets to calculate the
gt; gt; gt; length of time between two dates. When I look at the spreadsheet on my
gt; gt; gt; computer, the formula displays the correct answer, and also does so on
gt; gt; gt; most
gt; gt; gt; of my co-workers computers. However, for on co-worker, she gets the error
gt; gt; gt; quot;#NAME.quot; I think it is a setting on her computer, but cannot find one.
gt; gt; gt; Any
gt; gt; gt; ideas, or am I missing the setting?
gt; gt;
gt; gt; Analysis ToolPak:
gt; gt; office.microsoft.com/en-gb/as...093441033.aspx
gt; gt; --
gt; gt; David Biddulph
gt; gt;
gt; gt;
gt;
gt;
gt;

Many thanks!

quot;David Biddulphquot; wrote:

gt; quot;JDubquot; gt; wrote in message
gt; ...
gt; gt;I have a the formula quot;YEARFRACquot; on one of my spreadsheets to calculate the
gt; gt; length of time between two dates. When I look at the spreadsheet on my
gt; gt; computer, the formula displays the correct answer, and also does so on
gt; gt; most
gt; gt; of my co-workers computers. However, for on co-worker, she gets the error
gt; gt; quot;#NAME.quot; I think it is a setting on her computer, but cannot find one.
gt; gt; Any
gt; gt; ideas, or am I missing the setting?
gt;
gt; Analysis ToolPak:
gt; office.microsoft.com/en-gb/as...093441033.aspx
gt; --
gt; David Biddulph
gt;
gt;
gt;