Excel Function : YEARFRAC

Download now!

Excel Function : YEARFRAC


Date and time


Returns the year fraction representing the number of whole days between start_date and end_date

Microsoft Excel Reference Page


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.