YEARFRAC

  • Updated

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").