Difference between revisions of "Documentation/How Tos/Calc: YEARFRAC function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
| Line 31: | Line 31: | ||
: returns <tt>'''0.498630136986'''</tt>. | : returns <tt>'''0.498630136986'''</tt>. | ||
| − | + | {{Documentation/SeeAlso| | |
| − | + | * [[Documentation/How_Tos/Calc: Date & Time functions#Financial date systems|Financial date systems]]''' | |
| − | + | * [[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]''' | |
| − | + | * [[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]]''' | |
| − | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
| − | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
=== Issues: === | === Issues: === | ||
* Excel and Calc both produce slightly erroneous results in some circumstances. | * Excel and Calc both produce slightly erroneous results in some circumstances. | ||
Revision as of 14:28, 25 February 2009
YEARFRAC
Returns the number of years including fraction between two dates.
This function is only available if the Analysis AddIn is installed.
Syntax:
YEARFRAC(startdate; enddate; basis)
- returns the number of years between the startdate and enddate; basis is an integer specifying the system of how many days are in a month or year, as follows:
| basis | day counting system |
|---|---|
| 0 | US (NASD) system. 30 days/month, 360 days/year (30/360) |
| 1 | Actual/actual |
| 2 | Actual/360 |
| 3 | Actual/365 |
| 4 | European 30/360 |
Example:
YEARFRAC("2007-01-01";"2009-07-01";0)
- returns 2.5.
YEARFRAC("2008-01-01";"2008-07-01";3)
- returns 0.498630136986.
Template:Documentation/SeeAlso
Issues:
- Excel and Calc both produce slightly erroneous results in some circumstances.
