HOW TO CALCULATE AGE FROM DATE OF BIRTH IN EXCEL WITH FORMULA IN 2024
HOW TO
CALCULATE AGE FROM DATE OF BIRTH IN EXCEL | Let's learn what is the formula to
calculate age from the date of birth in excel for all versions.
HOW TO CALCULATE AGE FROM DATE OF BIRTH IN EXCEL |
WHAT IS THE FORMULA TO CALCULATE AGE FROM DATE OF BIRTH IN EXCEL
Now, Let's
learn how to calculate age from date of
birth in Microsoft Excel for the windows
operating system. I will try to make it simple for you to understand
better even if you are a beginner or a student.
Okay,
so here I have some names and the detail. So let’s learn how do I calculate
age in YYYY MM DD in Excel live step by step.
Alex 12-Jan-86
Joy 02-04-99
Rock 02-05-00
Mariya 09-09-80
Dolli 01-01-85
Raj 03-05-11
Koli 02-05-96
Rahul 06-08-92
Joni 05-05-87
Rani 08-07-80
I want
to take the year, month, and date. So it's up to you. If you want to, you can
only take Year, or take a Month, or you can take the day.
Okay,
so the formula will be the same I will show
you below
First,
I want to take the year from the date of birth to formalize.
=DATEDIF(SELECT DATE OF BIRTH CELL LOCATION,TODAY(),"Y")
Okay, Use this function =datedif()
If you can't do that
if you open the bracket, select the date of birth, insert the comma and write today(), and
now open and close the bracket.
Insert the comma double quotation. If you want to take the
year just type Y if we want to take
the month the type M.
So first we're going to take the quotation and close the
quotation. Close the bracket, Finally hit the enter button, and boom.
So we got the Year.
Okay. Now hold the Month. Same thing, just a little tool
they gave on bracket select your date of birth.
Insert the comma and type it today open
And close the bracket.
Insert the former or double quotation.
And here I need to type the month, okay simple, and then
close the quotation close the docket enter, and boom.
So it will calculate the whole month. So we are not going to
take the only month after the years Okay and it will take only a month after
the like 36 years, a Total of 437 months. That's it.
If you want to take the entire month you can delete Y it. It will calculate the entire month if
you want to take the month after the year.
That's why it will take an Entire month to use M.
That's it. Now if you want to pick the date, type the second formula for calculating the Total Days –
=DATEDIF(SELECT DATE OF BIRTH CELL LOCATION,TODAY(),"MD")
Open the brackets select your date of birth, comma today
open-close bracket again comma and now reception, and this time I am the one
offered a quotation close the bracket into more details.
Name Date of Birth Year Total
Month Days Months
Alex 12-Jan-86 36 437 13307
5
So now you can apply this formula to all the entries.
That's it simple. So the formula is
simple to calculate what is your live age till now.
If you want to calculate your total months from your date
of birth using this formula in any version of Ms Excel.
AGE CALCULATOR IN EXCEL FORMULA
=DATEDIF(E5,TODAY(),"M")
If you just want to learn how to know only Days from your
birth in Excel then use this function –
=DATEDIF(E5,TODAY(),"D")
If you just want to calculate your months from 1-12 in MS Excel
then use this function –
=DATEDIF(E5,TODAY(),"YM")
So this is a simple step
to get the year from the date of birth in Excel.
No. |
Name |
Date of Birth |
Year |
Total Month |
Days |
Months |
1 |
Alex |
12-Jan-86 |
36 |
437 |
13307 |
5 |
2 |
Joy |
02-04-99 |
23 |
278 |
8479 |
2 |
3 |
Rock |
02-05-00 |
22 |
265 |
8083 |
1 |
4 |
Mariya |
09-09-80 |
41 |
501 |
15258 |
9 |
5 |
Dolli |
01-01-85 |
37 |
449 |
13683 |
5 |
6 |
Raj |
03-05-11 |
11 |
133 |
4065 |
1 |
7 |
Koli |
02-05-96 |
26 |
313 |
9544 |
1 |
8 |
Rahul |
06-08-92 |
29 |
358 |
10909 |
10 |
9 |
Joni |
05-05-87 |
35 |
421 |
12829 |
1 |
10 |
Rani |
08-07-80 |
41 |
503 |
15321 |
11 |
Thanks
for reading this article I hope you learned a lot of tricks and tips on how the age
calculator formula works in MS Excel worksheet.
There is one factor that always remains the same: the age calculator in Excel formula.
This mathematical
tool can be used to determine someone's age with 100% accuracy, no
matter what other factors are at play.
IF YOU WANT TO KNOW HOW MANY MINUTES OLD YOU ARE WITH THE FASTEST CALCULATOR THEN I HAVE SHARED THE BEST CALCULATOR ON THIS SITE.
Age
calculator logic-
To use the
age calculator in Excel formula, simply enter the person's date of birth
into a cell. This will output the person's age in years.
You can
also use the age calculator in Excel formula to determine the age of
something else, like a piece of fruit.
To do
this, simply enter the date that the item was created or harvested into a cell,
and then type its formula into another cell. This will output the age of the
item in years.
Conclude – Here I have explained in detail how to calculate age from date of birth in Microsoft Excel with a formula for all Microsoft Excel versions of the Windows operating system especially 2007, 2010, and 2013.. As well as I have given some best examples too for beginners in 2023.