YEARFRAC(...)
Age calculator 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
YEARFRAC takes two compulsory arguments that are start and end dates, and returns the no. of years.