YEARFRAC


Returns the number of years including fraction between two dates.

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.






 
Created with Zapof