How to Calculate Age By Date of Birth in Excel Office 365?
Tags: calculateagebydateof, kutoolsexceltutorial, kutools
Published: 2020-10-06 08:54:52

---
title: How to Calculate Age By Date of Birth in Excel Office 365?
published: true
date: 2020-10-05 12:05:13 UTC
tags: CalculateAgeByDateof,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-calculate-age-by-date-of-birth-in-excel-office-365/
---

In this tutorial, we will guide you to learn the steps to **Calculate Age By Date of Birth in Excel Office 365** using **Kutools.** 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)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Steps to Calculate Age By Date of Birth:

- Let’s consider the below examples to understand how to calculate age.

![Example date](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-5.png)<figcaption id="caption-attachment-15162">Example date</figcaption>

- First, you need to **select the empty cell** to display the result. Then, on the **Kutools Tab, select** the **Formula Helper** option, **choose** the **Formula Helper** option from the drop-down menu.

![Select Formula Helper option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Formula-Helper-option.png)<figcaption id="caption-attachment-14911">Select Formula Helper option</figcaption>

- It will open the **Formula Helper dialog box. **
- In that dialog box, you need to **choose** the **Math** option in the **Formula Type** box using the drop-down list.
- In the **Choose**  **a formula section** , **select Calculate age based on birthday** option.
- **Date box –** you need to **select** the **birthday cell** using the browse button under the **Arguments input** section.
- **Click** the **OK** button.

![Formula Helper dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Formula-Helper-dialog-box-3.png)<figcaption id="caption-attachment-15163">Formula Helper dialog box</figcaption>

- Then, it will display the age in the selected cell.
- Now, you need to drag the first cell down to fill the remaining cell and get the range of results as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-2.png)<figcaption id="caption-attachment-15164">Result</figcaption>

## Verdict:

In this tutorial, we guided you to learn the steps to **Calculate Age By Date of Birth in Excel Office 365** using **Kutools.** Kindly, share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Find the Most Common or Frequently Used Value(Word or Number) in a List in Excel](https://geekexcel.com/find-the-most-common-or-frequently-used-valueword-or-number-in-a-list-in-excel/)
- [How to Extract Substring Between Two Texts in Excel?](https://geekexcel.com/how-to-extract-substring-between-two-texts-in-excel/)