YEARFRAC(...)
Find years between two 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])
Practice YEARFRAC Formula at Sheetzoom
YEARFRAC formula at Microsoft help
0
We will use the function of YEARFRAC() that gives numbers of years between two given dates.