Table of Contents
Google Sheets is a versatile tool that can be used for various calculations, including calculating age from a given date of birth. By utilizing the built-in functions and formulas, users can easily determine the age of an individual based on their date of birth. This can be done by using the “DATEDIF” function, which calculates the difference between two dates in years, months, or days. By inputting the birthdate as the start date and the current date as the end date, the formula will automatically calculate the age. This feature of Google Sheets is useful for individuals or businesses who need to quickly determine the age of a person for various purposes, such as determining eligibility for certain services or products.
Google Sheets: Calculate Age from Date of Birth
You can use the following formulas to calculate age based on date of birth in Excel:
Formula 1: Calculate Age in Years (e.g. 23 years)
=DATEDIF(A2,NOW(),"y")
Formula 2: Calculate Age in Decimal Years (e.g. 23.567 years)
=YEARFRAC(A2,NOW())
Formula 3: Calculate Age in Years, Months, Days (e.g. 23 years, 6 months, 25 days)
=DATEDIF(A2,NOW(),"y")&" years, "&DATEDIF(A2,NOW(),"ym")&" months, "&DATEDIF(A2,NOW(),"md")&" days"
Each formula assumes that the date of birth is located in cell A2.
The following examples show how to use each formula in practice with the following date of births in Google Sheets:
Example 1: Calculate Age in Years
To convert the date of birth to age for cell A2, we can type the following formula into cell B2:
=DATEDIF(A2,NOW(),"y")
We can then click and drag this formula down to each remaining cell in column B:
Column B displays the age for each birth date in column A in terms of years.
Example 2: Calculate Age in Decimal Years
=YEARFRAC(A2,NOW())
We can then click and drag this formula down to each remaining cell in column B:
Column B displays the age for each birth date in column A in terms of decimal years.
Example 3: Convert Date of Birth to Age in Years, Months, Days
To convert the date of birth to an age in years, months and days for cell A2, we can type the following formula into cell B2:
=DATEDIF(A2,NOW(),"y")&" years, "&DATEDIF(A2,NOW(),"ym")&" months, "&DATEDIF(A2,NOW(),"md")&" days"
We can then click and drag this formula down to each remaining cell in column B:
Column B displays the age for each birth date in column A in terms of years, months, and days.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets: