Excel Formulas to Calculate the Age From Birthday ~ Useful Guide!!
Tags: excelformula, excelformulas
Published: 2021-05-13 05:29:55

---
title: Excel Formulas to Calculate the Age From Birthday ~ Useful Guide!!
published: true
date: 2021-05-12 09:52:54 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-the-age-from-birthday/
---

Using a combination of Excel functions and the date of birth, you can easily calculate age in Excel. For example, you have a range of various birthday dates in Excel, and you need to **calculate the exact age from these birthdates**. This article provides some quick tricks to solve it. Let’s get started!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Get age from birthday](https://geekexcel.com/wp-content/uploads/2021/05/Get-age-from-birthday.png)](https://geekexcel.com/excel-formulas-to-calculate-the-age-from-birthday/get-age-from-birthday/#main)<figcaption id="caption-attachment-40835">Get age from birthday</figcaption>

## Generic Formula:

- To get the age from the birthdate, you can use the below formula.

**=[DATEDIF](https://geekexcel.com/how-to-use-datedif-function-in-microsoft-excel-365/)(birthdate,[TODAY](https://geekexcel.com/how-to-use-excel-today-function-in-office-365-simple-steps/)(),”y”)**

## Syntax Explanations:

- **DATEDIF** – This function will help to calculate the difference between the two dates. Read more on the **[DATEDIF function](https://geekexcel.com/how-to-use-datedif-function-in-microsoft-excel-365/)**.
- **TODAY** – In Excel, the **[TODAY function](https://geekexcel.com/how-to-use-excel-today-function-in-office-365-simple-steps/)** will help to know the current date on your workbook.
- **Birthdate** – It represents the input dates from your worksheet.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

- First, we will enter the input names with the corresponding Birthdates in **Column B** and **Column C**.
- Now we have to calculate the exact age from these input date.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/05/Input-Ranges-21.png)<figcaption id="caption-attachment-40836">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-38.png)<figcaption id="caption-attachment-40834">Enter the formula</figcaption>

- Finally, press  **ENTER**  to get the result out, if you need, drag the fill handle over range to apply the formula.

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-36.png)<figcaption id="caption-attachment-40837">Result</figcaption>

## Conclusion:

Here we have described the easiest way to calculate the age from birthdays in Excel. I hope that this article is helpful. Please share your **query** below in the **comment** box. We will assist you.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Count Weekdays between Two Dates ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-count-weekdays-between-dates/)**
- **[Formulas for Counting the Times a Word Appears in a Cell in Excel!!](https://geekexcel.com/formulas-for-counting-the-times-a-word-appears-in-a-cell-in-excel/)**
- **[Formulas for Counting Unique dates in a range in Excel Office 365!!](https://geekexcel.com/formulas-for-counting-unique-dates-in-a-range-in-excel-office-365/)**
- **[Excel Formulas to Count Dates in Current Month ~ Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-count-dates-in-current-month-simple-tutorial/)**