Excel Formulas for Calculating Age by Date of Birth ~ Easy Guide!!
Tags: excel, excelformula, excelformulas
Published: 2020-10-22 12:15:11

---
title: Excel Formulas for Calculating Age by Date of Birth ~ Easy Guide!!
published: true
date: 2020-10-22 08:38:05 UTC
tags: Excel,ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-for-calculating-age-by-date-of-birth-easy-guide/
---

This page will give you detailed information on the **Formulas for Calculating Age by Date of Birth in  Excel Office 365** with its basic syntax and explanations. Let’s get into this article!! 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)
## Formula Syntax:

- The below formula will help you to **[Calculate the Age by Date of Birth in Excel](https://geekexcel.com/how-to-calculate-age-by-date-of-birth-in-excel-office-365/)**.

**=[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)([ISBLANK](https://geekexcel.com/how-to-use-isblank-function-in-microsoft-excel-365/)([$B$2](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/)),””,[DATEDIF](https://geekexcel.com/how-to-use-datedif-function-in-microsoft-excel-365/)($B$2,[NOW](https://geekexcel.com/how-to-use-now-function-in-microsoft-excel-365/)(),”Y”))**

### Example:

- In the below screenshot, we give the input Name and Birthday in **Column**  **A** & **Column**  **B**.
- Then enter the given formula in the selected formula bar section.
- Finally, it will show the output as shown below.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-2.png)

## Syntax Explanations:

- **IF** – The Excel [**IF Function**](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/) is used to return one value as a TRUE result, and another value as a FALSE result.
- **ISBLANK** – The main purpose of this function is to return TRUE when a cell contains is empty, and FALSE when a cell contains any text. Read more on **[ISBLANK Function](https://geekexcel.com/how-to-use-isblank-function-in-microsoft-excel-365/)**.
- **DATEDIF** – It will calculate the difference between two dates in Excel. Read more on the **[DATEDIF Function](https://geekexcel.com/how-to-use-datedif-function-in-microsoft-excel-365/)**.
- **NOW** – The [**NOW**   **Function**](https://geekexcel.com/how-to-use-now-function-in-microsoft-excel-365/) in Excel returns the current date and time.
- **Absolute Reference ($)** – The**[Absolute reference](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/)** function in Excel is an actual fixed location in the worksheet. It won’t be changed when copied to a new location.
- **Comma (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – This symbol will help to group the elements.

## Wrap-Up:

From this article, you can understand the formulas and functions in Excel Office 365 with a suitable example. You can also learn the **formulas for calculating age by date of birth**. If you have any **doubts/queries,** feel free to share it with us. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!!**