by

How to Calculate Age in Excel

How to Calculate Age in Excel

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”

1589445002 134 How to Calculate Age in

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

Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

News Feed