Excel YEARFRAC function

Function              YEARFRAC

Description        Excel YEARFRAC function calculates the difference between two dates in fraction of years.

Syntax  YEARFRAC(start_date, end_date, [basis])

Start_date    Required. A date that represents the start date.

End_date    Required. A date that represents the end date.

Basis    Optional. The type of day count basis to use.

Basis	Day count basis
0 or omitted	US (NASD) 30/360
1	Actual/actual
2	Actual/360
3	Actual/365
4	European 30/360

Click Here to see posts related to YEARFRAC