Formulas > =YEARFRAC()
How to Use YEARFRAC() in Google Sheets
Description
How To Actually Use YEARFRAC() in Sheets
YEARFRAC(start_date, end_date, [day_count_convention])
Try YEARFRAC yourself
Use the YEARFRAC formula to calculate the number of years between the dates in cells A1 and B1. The result should be displayed in cell C1.
Hints (2)
-
Make sure to reference the correct cells for the start and end dates.
-
Remember that YEARFRAC can take an optional third argument for day count convention.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the YEARFRAC() formula:
Generate a YEARFRAC() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses YEARFRAC(). 2 free AI generations, no signup. Members get unlimited use.
Generate a YEARFRAC() formula