81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Returns the number of years, including fractional years, between two dates using a specified day count convention.

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.