Excel Function : YEARFRAC
Category
Date and time
Description
Returns the year fraction representing the number of whole days between start_date and end_date
Microsoft Excel Reference Page
https://support.office.com/en-us/article/YEARFRAC-function-3844141e-c76d-4143-82b6-208454ddc6a8
Syntax and Description of the YEARFRAC Excel Function
The syntax for the YEARFRAC excel function is as follows: YEARFRAC(start_date, end_date, basis) start_date - The start date for the calculation. end_date - The end date for the calculation. basis - The type of day count basis to use.
About YEARFRAC Excel Function
The YEARFRAC function returns the number of years between two dates. The number of days between the two dates is divided by the number of days in a year.