Learn how to calculate age in Excel in simple ways. read the article to know more.
It is very easy to calculate dates with the help of date of birth and Excel functions.
Table of Contents
How To Calculate Age In Excel
Let us learn how to:
1. The number of years elapsed till the specified date.
2. The number of Years, Months, and Days elapsed till the specified date.
Calculate Age in Excel – Years Only
Let’s suppose that we have the date of birth in cell B1, and want to calculate how many years have elapsed since that date.
To do so, here is the formula:
=DATEDIF(B1,TODAY(),”Y”)
You can use the reference if not the TODAY function if you have the current date (or the end date) in a cell. For example, if you have the current date in cell B2, use the formula:
=DATEDIF(B1,B2,”Y”)
Use the YEARFRAC function to calculate the age in Excel (in years) in the specified date range.
The formula is:
=INT(YEARFRAC(B1,TODAY()))
The YEARFRAC function returns the number of years between the two specified dates and then the INT function returns only the integer part of the value.
Calculate Age in Excel – Years, Months, & Days
For example, if you have the date of birth in cell A1, here are the formulas:
To get the year value:
=DATEDIF(B1,TODAY(),”Y”)
To get the monthly value:
=DATEDIF(B1,TODAY(),”YM”)
To get the day value:
=DATEDIF(B1,TODAY(),”MD”)
Now that you know how to calculate the years, months and days, you can combine these three to get a text that says 26 Years, 2 Months, and 13 Days.
Also Read
How to unhide columns in Excel
How to remove scroll lock in Excel
How to change date format in Excel
Here is the formula that will get this done:
=DATEDIF(B1,TODAY(),”Y”)&” Years “&DATEDIF(B1,TODAY(),”YM”)&” Months “&DATEDIF(B1,TODAY(),”MD”)&” Days”
And this is how easy it is to calculate age in Excel. The next time you want to calculate it, you will be able to do it in no time.
CONCLUSION
Microsoft Excel is a well-known Microsoft Office application. It is a spreadsheet program for saving, analyzing, and filtering data.
We can carry out numerous operations with Microsoft Excel, including computations, average calculation, concatenation in Excel, and more.
EasySheet is a tech blog where you can find amazing Excel hacks, tips, and tricks. Our mission is to help beginners learn Excel and get answers to all of their questions using the Easy Sheet.
We are the best place to go for anyone who needs assistance with Microsoft Office products such as Excel, Word, PowerPoint, Publisher, and others.
