The YEARFRAC() formula takes three arguments, the start date, the end date and an optional argument to give you the year count.
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