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.
Category: Date and time
Returns the year fraction representing the number of whole days between start_date and end_date
YEARFRAC(start_date, end_date, [basis])
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM