Calculates the difference in years, including fractional years, between two dates, using a specified day-count method.
Sample Usage
YEARFRAC("12/6/1990","6/6/2010")
YEARFRAC(C4, C5)
Syntax
YEARFRAC(value1, value2, [type])
- value1 - The start date to consider.
- value1 - The end date to consider.
- type - [OPTIONAL] The calculation method to use.
- 0 or omitted: US 30/360 day count. This mode calculates based on 30 day months and 360 day years with end-of-month date adjustment according to US NASD standards.
- 1: Actual/actual. This mode calculates based on the actual number of days between the specified dates, and the actual number of days in the intervening years.
- 2: Actual/360. This mode calculates based on the actual number of days between the specified dates, and 360 day years.
- 3: Actual/365. This mode calculates based on the actual number of days between the specified dates, and 365 day years.
- 4: European 30/360. This mode calculates based on 30 day months and 360 day years with end-of-month date adjustment according to European standards.
Examples
YEARFRAC("12/6/1990","6/6/2010") returns the value 19.5.
YEARFRAC(C4, C5) returns the fraction of the years between C4 and C5.
Notes
Ensure that you use quotation marks while passing dates as arguments. YEARFRAC("12/6/1990","6/6/2010").