Difference between revisions of "Documentation/How Tos/Calc: YEARFRAC function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
|||
| Line 73: | Line 73: | ||
* Excel and Calc both produce slightly erroneous results in some circumstances. | * Excel and Calc both produce slightly erroneous results in some circumstances. | ||
| − | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: Date & Time functions#Financial date systems|Financial date systems]] | * [[Documentation/How_Tos/Calc: Date & Time functions#Financial date systems|Financial date systems]] | ||
Revision as of 07:25, 17 July 2018
CALC FUNCTIONS
- Date & Time Functions
- TodayNowYearMonthDayWeekdayHourMinuteSecondDateDatevalueTimeTimevalueEomonthEdateWorkdayNetworkdaysDaysDays360DaysinmonthDaysinyearWeeksWeeksinyearWeeknumWeeknum_addMonthsYears
Contents
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.
Issues:
- Excel and Calc both produce slightly erroneous results in some circumstances.
See Also
-
