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

SORRY NOT WORKING

sorry not working

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

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!

Thanks

But in my computer it didn't work your formulae

Not working for me

kalau lahir 18 03 1966 berapa umur nya

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

I TRY ALL ITS STILL SHOWING VALUE AND NAME

THANK YOU!!!

Nice Excellence To Work Amazing teaching way thank you so much

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

Doesnt Work.. Poor video

Can you teach us a formula for displaying ages in year, month and days? i.e. 12 years 3 months, 5 days please?

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

told me error formula so what should i do

Thanks sir, you solved my problem

Awesome

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

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?

very easy way...👍

Thank you 😍 it really helps me in my office work 🥰

WHY "Y"

Brilliant and simple. You earned my sub!

I have Excel 2021 but there's no DATEDIF function

Will this automatically update the age each year?

Thanks for help

Excellent tutorial! Simple and Clear!

Perfect, thank you

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

I got an Error !

That's awesome. THANK you so much

Love love it... is there a way to calculate precise age (i.e. year month and date)?

Thank you for support

Music is haram

Music

Thanku so much Frank 😊😊

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

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

Worked...
Thanks.
India...

Nice one formula

Not working

Thank you for the excellent tutorial!

So much better and easy than what others have explained

Appreciate your help.

Is it work in ms excel 2007

HOW TO AGE TO DOB

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

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