How to Calculate Age in Excel

## How to Calculate Age in Excel

How to calculate age in Excel, there are many ways to calculate age in Microsoft Excel, but today we will tell you the simplest method that you can use to easily calculate can also know the age.

As you can see in the example below.

We have written the date of birth in cell B1.

And then in B2 today’s date is written.

And now comes the formula we wrote in B3, which allows you to calculate age in Excel.

**Formula: =DATEDIF(B1,B2,”Y”) & ” Years, “ & DATEDIF(B1,B2,”YM”) & ” Months, “ & DATEDIF(B1,B2,”MD”) & ” Days”**

Now it seems to me that after understanding this formula you may have understood how to calculate age in Microsoft Excel.

## Comment