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
#excel #googlesheets #age #yearsfoservice
