Table of Contents
In Excel, there are various ways to convert a date of birth to age. One method is to use the DATEDIF function, which calculates the difference between two dates in years, months, or days. Another method is to use the YEARFRAC function, which calculates the number of years between two dates including fractions of a year. Additionally, the TODAY function can be used to automatically update the age calculation based on the current date. For example, if the date of birth is entered as “7/12/1985” and the current date is “9/1/2021,” the age would be calculated as 35.
Convert Date of Birth to Age in Excel (With Examples)
You can use the following formulas to convert date of birth to age in Excel:
Formula 1: Convert Date of Birth to Age in Years (e.g. 23 years)
=DATEDIF(A2,NOW(),"y")
Formula 2: Convert Date of Birth to Age in Decimal Years (e.g. 23.567 years)
=YEARFRAC(A2,NOW())Formula 3: Convert Date of Birth to 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 list of birth dates in Excel:
Example 1: Convert Date of Birth to 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: Convert Date of Birth to 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.
The following tutorials explain how to perform other common tasks in Excel:
Cite this article
stats writer (2024). How can I convert a date of birth to age in Excel, and what are some examples of how to do so?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-convert-a-date-of-birth-to-age-in-excel-and-what-are-some-examples-of-how-to-do-so/
stats writer. "How can I convert a date of birth to age in Excel, and what are some examples of how to do so?." PSYCHOLOGICAL SCALES, 25 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-convert-a-date-of-birth-to-age-in-excel-and-what-are-some-examples-of-how-to-do-so/.
stats writer. "How can I convert a date of birth to age in Excel, and what are some examples of how to do so?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-convert-a-date-of-birth-to-age-in-excel-and-what-are-some-examples-of-how-to-do-so/.
stats writer (2024) 'How can I convert a date of birth to age in Excel, and what are some examples of how to do so?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-convert-a-date-of-birth-to-age-in-excel-and-what-are-some-examples-of-how-to-do-so/.
[1] stats writer, "How can I convert a date of birth to age in Excel, and what are some examples of how to do so?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I convert a date of birth to age in Excel, and what are some examples of how to do so?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.