Please enable JavaScript to view the comments powered by Disqus.


YEARFRAC(...B4,B5,0)

Calculate years between two dates

The YEARFRAC() formula takes three arguments, the start date, the end date and an optional argument to give you the year count. 


Used Functions

Category: Date and time

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

Syntax

YEARFRAC(start_date, end_date, [basis])

Lets chat on this