HOW TO CALCULATE AGE FROM DATE OF BIRTH IN EXCEL WITH FORMULA IN 2024

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
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.

Post a Comment (0)
Previous Post Next Post