Brian Barker wrote:
At 10:16 03/07/2008 -0700, Joe Conner wrote:
In Calc, help files, the function YEARFRAC (Start date;End
date;Basis) requires the Analysis AddIn. Where do I get this
Analysis AddIn? How do I install it once I download it?
My experience - and a bit of searching at the web site - suggest that
the help text is being less than helpful here. It seems that the
analysis functions are actually installed by default - but that this
can be deselected in the custom installation route. Certainly my
default installation of 2.4.1 on Windows XP includes the analysis
functions. Copying the help text's example for YEARFRAC() produces
the expected result (give or take that my locale requires a different
date format).
What happens if you attempt to user YEARFRAC() ? Do you get an error?
I trust this helps.
Brian Barker
Thanks. That helped.
I had left out the quotation marks around the dates. Too bad you cannot
enter the dates in the formula the same way as when you enter a date in
a cell. It is goofy to change the formatting because the function
interpreter is not smart enough to recognize a date format.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
