How To Calculate Age From Date Of Birth In Excel {Easy Way} 2021

Hello all, welcome to EasyMySite.com and I’m back again with another awesome article. In this post I’ll show you how to calculate age from date of Birth in Excel in any version in an easy way.

Calculate Age From Date Of Birth In Excel

Method shown in this article to calculate age in Excel, not only applies when you want to calculate age but also when you are looking for how to calculate the difference between two dates in Excel in terms of years, months, and days, then this post is for you.

But before going forward make sure you subscribe to my YouTube Channel by clicking on the subscribe button and click on the bell icon also you can join us on our Facebook Page and Twitter so that you never miss any of my latest videos.

How To Calculate Age From Date Of Birth In Excel {Easy Way} 2021

As the stage has been set let us see how to calculate age in excel in terms of years months and days with a simple formula. So, let me open my Excel Sheet and you could see that the first entry is the date of birth and the next entry is the current date.

So, I want to calculate difference between two dates, so that I would know age in terms of years months and days. So, simple excel formula which we are using to calculate age in excel is “DATEDIF“.

datedif function

This is nothing but, date differences or difference between two dates. So, head over to the cell where you want to calculate years between two dates and just type “=datedif” .

You won’t see that there is no intelligence but this formula works even starting from the Excel any version to the latest Excel Sheet. Just type “=datedif” open the parenthesis select the from date, comma select the to date comma and next parameter is the value which you want like years or months or days.

As I want years between the two dates, just type capital “Y” between the double quotes and hit enter. You could see that it has calculated years between two dates. Next comes the number of months, which you want to calculate.

how to use the excel today function

So, give the formula and type the from date comma type the second date comma. If you give “M” in double quotes and hit enter, you could see that it has calculated the number of months between those two dates, but we want number of months after 25 years.

So, just edit the formula in a simple way saying that instead of “M” give it as “YM“, so that it calculates months after that number of years. So, hit enter and you could see that it has calculated 25 years and 7 months after 25 years.

how to calculate age from a specific date in excel

Now, let us see in the same way you want to calculate number of days, after those 7 months. So, give that formula followed by from date comma two date and in double quotes if you give it as capital “D” and it Enter and it calculates days difference between those two dates, but we want the number of days after 7 months.

So, edit the formula in a simple way, as you’ve done for months. So, instead of “D”, give it as “MD”, so that it calculates number of days after those 5 months and hit enter.

how to count age in excel

Now, you could see that the age is calculated from the given date of birth to the current date is 25 years, 7 months, and 2 days. So, this is a simple way to calculate age  Excel or the difference between two dates in Excel in terms of years, months, and days using a simple formula.

 

How To Calculate Age From Date Of Birth In Excel {Easy Way} YouTube

 

Related Articles:

 

 

 

Leave a Reply

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