How To Calculate Age In Google Sheets?
=int(YEARFRAC(A1,today())) You’ll add the birth date to cell A1 and paste the formula into B1 for the result. We’ll use the birth date 11/04/1983: The result is 35 years of age. Simple, just like when using the DATEDIF function for a single cell. What is the formula to calculate age? Calculate age Data =YEARFRAC(A3,A5) Calculates […]