How to Calculate Age Using a Date of Birth in Excel (The Easy Way)

[@pkamdar4u]

Instead of remembering the formula, don't you think the below logic is simpler. (Today's date - Date of birth)/365 and then drag it across Eg (10th march 2010 - 10th march 2000)/365 = 10.3 - if you remove decimal it will be 10 years. Not trying to challenge you, just asking your views.

[@anveshjadav]

Yes, I was using it e.g. =ROUND((TODAY()-F7)/365,0) where DOB is written in F7 cell

[@ExcelAtData]

@@anveshjadav Another solution is =INT((TODAY()- Date of birth)/365)

[@aregbeyenomotola3576]

This one worked for me

[@niceone5416]

This kind of things that no one serched for but every one need

[@kaiff0734]

Mc

[@HTN1990]

I got an Error !

[@justinegarcia3152]

doesnt work for me, it says "value!"

[@nrbbanklimited9014]

Why

[@19761999]

I had the same error so I changed the formatting in the "Age" column from number to general and it worked.

[@Angela3dom]

@@19761999 in my case it did not solved the problem, still VALUE error appears

[@motivation_not_enough]

Use now instead of today and date format should be match with ur system date and time

[@ExcelAtData]

SOLUTION: You are getting the error as the date is not in a date format. It is probably in a text format. You can change the cell format by right clicking > select Format Cells > select Date. If this doesn't work try using the formula DATEVALUE. i.e DATEDIF(DATEVALUE (date of birth), DATEVALUE(TODAY()), "Y"). Hope that helps.

[@veerabhadrakumar3460]

Thanks a lot, saved me from lot of stress and time

[@sandeepsharma5637]

It is showing '#Value!' instead of age after typing formula in cell.

[@harinarayanan2252]

Same here..did you get any solution for this

[@sandeepsharma5637]

@@harinarayanan2252 no

[@harinarayanan2252]

@@sandeepsharma5637 make the date format as 03-06-2021 not in 03.06.2021 ( avoid unnecessary space at the front of date)

[@ExcelAtData]

SOLUTION: You are getting the error as the date is not in a date format. It is probably in a text format. You can change the cell format by right clicking > select Format Cells > select Date. If this doesn't work try using the formula DATEVALUE. i.e DATEDIF(DATEVALUE (date of birth), DATEVALUE(TODAY()), "Y"). Hope that helps.

[@lopamudraparida8119]

@@ExcelAtData apki formula se bhi results nenhi araha

[@md.inzamamulalamchowdhury2669]

Formula: =datedif(XN,Today(),"Y") Where X= A/B/C.... N= 1,2,3.....

[@JanMSco]

I use this formula in a Birthday/Anniversary list for my family. It works great until it encounters a Month/Day that hasn't yet occurred. Then the age is off by 1 year. Any ideas how to fix this?

[@AhadCreation4m]

Sir your video is fantastic but please tell me intro sound name

[@AhadCreation4m]

Intro sound name bta do sir please

[@jpkamalanathan3859]

Super Sir Sir I Want Excel practice files for every video Can you upload the Excel files next time because it's very useful for everyone Thankyou

[@ExcelTutorialsEasyClickAcademy]

J P Kamalanathan, thank you for your feedback and also for your great tip. :)

[@fatima6139]

my date of birth is 30 april 1999 what is my age now?

[@akapic]

the formula doesn't work if the year used is 1800, 1700, etc. Works only for 1900 and 2000

[@snuffy467]

Excel uses the number of days since 1 January, 1900 for dates. Most people born before then are dead.

[@valmir144]

@@snuffy467 LOL!!!!

[@tamaglibatos565]

It does not work

[@sstanyroch]

Somebody help me why am I not getting the answer for the below 30-07-1990 =DATEDIF(F254,NOW(),"y") Not showing the date why? it is supposed to be 31

[@sachibaath6866]

Don't type NOW Type Today.

[@victorrajrocque8305]

Thank you man, you have helped resolve a life long pending issue of mine. Thanx again!!!

[@popstarbarbie0925]

How about if I want to calculate their age for the year 2021? Pls help me thanks.

[@ExcelAtData]

The formula is DATEDIF(date of birth, TODAY(), "Y"). The TODAY() gives you today's date, so it will be for 2021. You can change TODAY() to any date you like. For example, if you wanted to know how old someone was at the start of 2021, then you can change it to 01/01/2021. Hope that helps. Let me know if you have any questions.

[@caseyholley5265]

Much better and detailed than anything else I have found.

[@AhadCreation4m]

Intro sound kaun sa hai please reply

[@AhadCreation4m]

Please reply

[@JasonCrozier-gx5pw]

Age 37 this is Jason will be 38

[@kevinhammond3060]

I've just discovered this site and am very impressed. Thank you so much!!

[@zahir2023]

Thank you so much. It was a big lesson for me to learn this age calculating formula.

[@ramshadmuhammed4783]

HOW CAN I AVOID ZERO IN AGE CELL, IF DATE OF BIRTH IS NOT ENTERED

[@SyedUsman]

Use if(cell="","",age)

[@AhadCreation4m]

Intro sound name

[@AhadCreation4m]

Intro sound name

[@shoebrahaman209]

How old am i if i born in 2004??

[@ExcelAtData]

Depending on the date of birth, either 16 or 17 in 2021.

[@brandonneverdies]

Thank you, very simple and clear explanation

[@nabammanie7607]

Not working..15/2/2002 please calculate this for me... it's not working

[@MRegyy]

When I say my age is 22 years 2 months, what does that mean? My 22 has started or my 23 has started?

[@propertytoinvestbymary5099]

My first time and i immediately subscribed! Very helpful videos. Thank you so much🙂

[@rafiullahafridi11]

Sir if you have this file of excel plz open the sheet and delete B3 cell than see what's happening. It means that if we have a blank cell in Column B the result in Column C will be show "121" so plz make another video to resolve this problem i will be very thankful of you. Thank you

[@ExcelAtData]

You can use the IF function. The formula is IF(logical_test, value_if_true, [value_if_false]). So in this case use =IF(B3="","",DATEDIF(B3, TODAY(), "Y")). The logical test is B3="", as there is nothing inside the double quotations, it means if B3 is blank then it will output no value otherwise output the age. Hope that helps.

[@rafiullahafridi11]

@@ExcelAtData ok thank you so much

[@manju6326]

Funtion not working sir, please solve, my exel is 2007

[@ExcelTutorialsEasyClickAcademy]

Manjunath, get the most from Office with Microsoft 365: www.easyclickacademy.com/buy-microsoft-office/

[@redhaal-obaidy2217]

Thanks for sharing dear, much appreciated and really helpful method.

[@JAFlightSimulatorWorld]

If I have the age 22Y 11M 24D can I convert it to birth date?

[@ElijahParantai]

It's great 🎉🎉🎉

[@amoamasamt]

That's great. So easy when you're shown how. The only question I have is, how do I calculate the age without it changing with time. I would like to keep the age of the person when I received the application, for example. Would I remove the Today reference? Thank you for any help! Your instructions are so clear and straightforward.

[@bestmail1893]

But excel not Perfered this formula due error expect at time of applying Excell pop-up will warn you

[@daayemshehzad]

AMAZING AND THANK YOU. Tried something extremely similar to this but I was just having a syntax issue. I didnt know the Datedif() function and was trying a different function with the same logic. You are a gentleman and a scholar!

[@PC-so4lg]

I have not found one teaching the shortcuts of computer... No one!!! Jaan de dena jyada aasaan lagta hai... Interview main 5 line bolna aaj tak koi dhang k nahi sikhate... Jaahilo ki bharti!!!

[@tommyharris5817]

I have Excel 2021 but there's no DATEDIF function

[@bonginkosimalangenidlamini4355]

what happens if another year or two pass after my calculation today, is the whole data going to update itself or I should update it from time to time

[@savitathakur3064]

Doesn't work

[@reginajohnson188]

I just used my birth year and the current year and subtract years the old 🗝️ fashion way

[@thesaadshah7]

Can anyone tell me how to do the other way around. If I put age, how to show Date Of Birth?

[@duvvurianil9479]

Your explain very clearly but it is not working in Windows 7

[@ExcelTutorialsEasyClickAcademy]

Thank you, Duvvuri :) Are you using Microsoft 365? Get it here: www.easyclickacademy.com/buy-microsoft-office/

[@ThereseFilhiol]

Saved me literally hours of tedious calculation. Thanks for providing this resource!

[@md.shamsalhoda4798]

Thank You very much You explain very nicely

[@phoenix_ever]

Great....thanks for it, but why is that I don't have the datedif function enabled on my excel, any solutions

[@captainkeyboard1007]

This tip was great. I am pleased that I can do it in Excel. I have seen that it can be accomplished in Access, but I want to use Excel more. I love your tip very much.

[@captainkeyboard1007]

@@sovannsom2643 Access and Excel are very fine programs. They both have unique powers to perform some heavy-duty jobs with ease. Thank you for writing to me.

[@kanglimpichrathanak3927]

it doesn't work on mac book pro

[@vikingraven4156]

tried it,dosen't work all I get in cell is value

[@njokimuhoho5518]

Excellent. Simple straightforward. You sorted me out!! Blessings!!

[@jagritisaraf4785]

It is really very amazing 🤗

[@samuelpackia5946]

Hi.. how to calculate no.of.days excluding Saturday and Sunday? If we use the same formula

[@Књаз]

Why doesn't my excel have this datedif formula?

[@juliajulia2039]

kalau lahir 18 03 1966 berapa umur nya

[@greglapura2495]

but what if the other way around. the age is given and how to determine the birthdate

[@sureshv7724]

Thanks sir. Wonderful much needed. Can you explain how to hide excel formula.

[@angelarodriguez6426]

Oh my gosh, Works beautiful. Saves so mudh time..Thank you!!💖💖

[@kugatharsa6588]

How to find birth year month date Sri lankan nic number.

[@sophanasorn6218]

Hi admin you should upload to short so it's more interesting ❤

[@yussufhassan5265]

This is what i like and dislike a whole vedio for 2 hours with no meaning

[@GregoryITguy]

For me, the best tip is here is tell you that you must format birthdate column as date, and age column as NUMBER. No guides I searched for told me this!

[@sweetydidi3515]

Sir agar kisi ka age only year me diya hai to usko dd/mm/yy form me kaise convert karenge? Jaise kisi ka birth year 1991 me ho to usko 01/01/1991 me convert karne ke liye kaun sa formula lagana padega? '

[@loislong6821]

what if I have age but need date of birth. How to calculate that?

[@spearlightknight1714]

AWESOME! Love the concise and how articulate the explanation is. Thank you! Made my work easier!

[@zardbilly]

Could you guide me, if I have a worksheet to store all the events by date. How can I just display today's events in a separate worksheet?

[@usamasaadshaik]

Try searching about filters and advanced filters.

[@sankarshanaswain7417]

Wao, nice

[@mohdnadeem5811]

Nice Excellence To Work Amazing teaching way thank you so much

[@kishorehs4999]

It's doesn't work properly in my excel

[@ExcelTutorialsEasyClickAcademy]

Kishore do you use Microsoft 365? Get the most from Office with Microsoft 365: www.easyclickacademy.com/buy-microsoft-office/

[@charithrukshandenis8477]

Thank you so much. Explanation was wonderful and was able to do that.

[@blueamour9628]

THANK YOU FOR SHARING US YOUR EASY EXCEL AGE CALCULATION I LIKE IT BECAUSE IT HELPS A LOT IN MY OFFICE WORK

[@herohamza1196]

just came here to learn Date Calculate mikasa's birth

[@vikkilouflores3626]

big help to me..thanks

[@jahgents4095]

Doesnt work it says #NAME

[@ExcelAtData]

Which version of Excel are you using. The #NAME error appears when Excel doesn't have the function. It was officially recognised and introduced by Microsoft in Excel 2016. You can use =INT((TODAY()- Date of birth)/365) instead, this will also work. Hope that helps.

[@bikeshkumarjha2415]

But in my computer it didn't work your formulae

[@vibhorbhatnagar5372]

Very nice explanation Sir. God bless you. Love from India.

[@jorickritsema3473]

Hi, If I enter the exact same formula with only another cell location for date of birth I got an error. Can you see what I did wrong? =DATEDIF(H2,TODAY(),"Y")

[@abhishekagarwal937]

THANK YOU SO MUCH NOBODY TOLD ME ABOUT THE’ FORMAT CELL’ option

[@JenniferParsore]

Thanks 👍 I got it as you did ,,,, I found it helpful 🙏🙏🙏

[@anonymouse6703]

Will this automatically update the age each year?

[@عصفورطلمنالشباكالزمنالجميل]

Thank you so much 👍🏻👏🏻👏🏻👏🏻👏🏻

[@SelvaKumar-jq7or]

current date month year - date of birth will also give solution

[@spongeesponge9623]

No datedif...how to add this in my function?

[@shailesh1142]

GREAT !!! HELLO ITS REALLY WORKS !!! GOOD HAVE A BEAUTIFUL FUTURE :-)

[@anekeooatel9434]

Thanks a lot Sir. I've been looking for this specific part.

[@ankitdixit719]

Is it work in ms excel 2007

[@cristinasosa9826]

THANKYOU VERY MUCH!!!!

[@khaledhasan6998]

Thank u very much Would you give us its Cod ???

[@mypointofview5647]

Today only I seen the video .your explanation is easy to understand thank you so much 👍👍👍

[@priyankachourasiya9712]

Your all doing step by step and see you right answer 😊

[@priyankachourasiya9712]

Hey... But in my case I will do in same ...

[@kanglimpichrathanak3927]

Do you any idea?????

[@adriancaldeira7883]

when i drag this format to the next cell this format prompts an error and shows results in -99, -76 etc

[@husayn5]

People born in 1987 are 41 years ?

[@jyotisupne870]

Bhai tera work, mere exel main work Q ni kr raha🤣

[@rghssecurity7632]

I TRY ALL ITS STILL SHOWING VALUE AND NAME

[@sunandabhattacharyya8275]

TOO GOOD .. tHANK YOU

[@ExcelTutorialsEasyClickAcademy]

You’re Welcome :)

[@risingstar5162]

Not working .result comes value

[@bhavanakomari5164]

November 27 2003 what is my age sir please tell me