Please enable JavaScript to view the comments powered by Disqus.


YEARFRAC(...B4,B5,0)

Calculate number of years between two dates

We can find the number of years between two dates by using MS Excels YEARFRAC() function. This takes as argument start and the end date and an optional argument and returns number of years.


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