Excel Function : YEARFRAC

Download now!

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.