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
81% OFF online library of tutorials for mastering Google Sheets
One time purchase $199
Description
How To Use in Sheets
YEARFRAC(start_date, end_date, [day_count_convention])
External Links
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.