Table of Contents
Excel is a powerful tool that can be used to easily calculate someone’s age in a specific date format. By using Excel’s built-in functions and formulas, it is possible to accurately determine a person’s age in dd/mm/yyyy format. This can be achieved by inputting the person’s birthdate in one cell and the current date in another, and then using the DATEDIF function to calculate the difference between the two dates in years, months, or days. With this method, users can quickly and efficiently calculate someone’s age in the desired format, making it a convenient and reliable tool for age calculation.
Excel: Calculate Age in dd/mm/yyyy
You can use the following formulas to calculate age based on a birth date in dd/mm/yyyy format in Excel:
Formula 1: Calculate Age in Years (e.g. 32 years)
=DATEDIF(B2,NOW(),"y")
Formula 2: Calculate Age in Decimal Years (e.g. 32.597 years)
=YEARFRAC(B2,NOW())Formula 3: Calculate Age in Years, Months, Days (e.g. 32 years, 7 months, 5 days)
=DATEDIF(B2,TODAY(),"y")&" years, "&DATEDIF(B2,TODAY(),"ym")&" months, "&DATEDIF(B2,TODAY(),"md")&" days"Each formula assumes that the birth date is located in cell B2.
The following examples show how to use each formula in practice with the following list of birth dates in Excel:
Example 1: Calculate Age in Years
To convert the date of birth to age for cell B2, we can type the following formula into cell C2:
=DATEDIF(A2,TODAY(),"y")We can then click and drag this formula down to each remaining cell in column C:
Column C displays the age for each birth date in column B in terms of years.
Example 2: Calculate Age in Decimal Years
=YEARFRAC(B2,TODAY())
We can then click and drag this formula down to each remaining cell in column C:
Column C displays the age for each birth date in column B in terms of decimal years.
Example 3: Calculate Age in Years, Months, Days
To calculate age in years, months and days for cell B2, we can type the following formula into cell C2:
=DATEDIF(B2,TODAY(),"y")&" years, "&DATEDIF(B2,TODAY(),"ym")&" months, "&DATEDIF(B2,TODAY(),"md")&" days"We can then click and drag this formula down to each remaining cell in column C:
Column C displays the age for each birth date in column B 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 use Excel to calculate someone’s age in dd/mm/yyyy format?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-excel-to-calculate-someones-age-in-dd-mm-yyyy-format/
stats writer. "How can I use Excel to calculate someone’s age in dd/mm/yyyy format?." PSYCHOLOGICAL SCALES, 23 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-excel-to-calculate-someones-age-in-dd-mm-yyyy-format/.
stats writer. "How can I use Excel to calculate someone’s age in dd/mm/yyyy format?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-excel-to-calculate-someones-age-in-dd-mm-yyyy-format/.
stats writer (2024) 'How can I use Excel to calculate someone’s age in dd/mm/yyyy format?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-excel-to-calculate-someones-age-in-dd-mm-yyyy-format/.
[1] stats writer, "How can I use Excel to calculate someone’s age in dd/mm/yyyy format?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use Excel to calculate someone’s age in dd/mm/yyyy format?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.