Please enable JavaScript to view the comments powered by Disqus.


YEARFRAC(...B4,B5,0)

Find years between two dates

We will use the function of YEARFRAC() that gives numbers of years between two given dates.


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