Returns the number of years, including fractional years, between two dates using a specified day count convention.
81% OFF online library of tutorials for mastering Google Sheets
YEARFRAC()
Description
How To Use in Sheets
YEARFRAC(start_date, end_date, [day_count_convention])
External Links
Age Calculation, Years of Service Formula in Excel & Google Sheets
In this tutorial first we'll cover how to calculate age from date of birth as of today using various formulas in Excel & Google Sheets, then we'll calculate years of service from hire date or simply between two dates, then we'll expand the formula by adding months or days in addition to years. Functions used: DATEDIF, YEARFRAC, TODAY, IF, SWITCH, TRIM
0Better Sheets Tutorials
No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.