How to Calculate Age from Date of Birth in MS Excel (Year, Month, Day)

Calculate Exact Year, Month, Days from Date of Birth In Excel
#CalculateAge #DateofBirth #MSExcel
Formula:
Years:
=DATEDIF(D4,TODAY(),"Y") (Change D4 to your date of Birth)
Months :
=DATEDIF(D4,TODAY(),"YM")
Days:
=DATEDIF(D4,TODAY(),"MD")
Facebook Page : / memjtube
Follow on twitter: / mj1111983
Website : www.bsocialshine.com

[@PrettyFaith35]

this is the only video that helped me to get this right! other videos i get error for the reason i dont know. thank you!!!💗💪

[@RakeshvlogsJH]

Thanks 👍 sir 😢😢🙏🙏🙏 aese hi video late rahie

[@BhagvaankeBhakt]

Very fantastic

[@sarajonikishan5669]

Thank you sir🙏🙏👍

[@Shriradhekrishna001.]

It's so help full thx

[@mansoorusman883]

why this parenthesis color is red.... i insert this formula but not working.

[@jondas2272]

Thanks sir.

[@PradeepKumar-ej9xo]

Thanks for this video

[@rohitverma7160]

Thanks for your information

[@atulgupta77]

What formatting should be there in the column, numbers, dates or general

[@Starkindustriesbyironman]

Thank you so much
my doubt are clear about the formula's of to how to make the DOB Sheet .
i am 10 years old child seeing this vdeio because i love ict
by Aayush kumar singh

[@s.smoters-bi1jw]

Thanks sir

[@MrJaipaul1]

U saved me lot of time

[@gouravbeniwal2137]

Wow Very helpfull video sir

[@prasantakutruka8990]

You made my day

[@kashifmumtaz007]

Thank you for sharing - Fantastic video

[@lanphiliparenque1843]

thank you for short and simple video but it helps a lot

[@Curiousbandaa]

Thanks for making this video

[@irshadbaruah7961]

Hi, if i want to know only the birth year from age, how to do that? let my year is 20 years, what I have to do see only the birth year?

[@puranyashkapoor7468]

Great Video! keep it up !!!

[@dilipkumardas7251]

It's very easy and simple

[@sabinasdream3307]

Very helpful

[@maheshwaradatta1587]

Thank u sir Pls upload more videos on Excel...........

[@rethinabalan5769]

Thanks for your video

[@rjh1394]

Can this calculation be done on a simple libre office table?

[@itsgauravrajput6108]

Tq for this video

[@TrusteestDesiChhora]

Thanks sar 💯❤️

[@AmitChandra_YouTube]

Thanks, Please show what if the year goes earlier than year 1900?

[@KAAMKIBAATAIN]

Thank you. It helped

[@rohitmewada3455]

thank you so much 😀

[@annamalaisuresh6235]

Thank you sir

[@marceljunioregondi5594]

This just made my work a whole lot easier.

[@rinatiriya6524]

Number formatting
1. Decimal number
Increase decimal number
Decreas decimal number

[@NitaFunnyVideo]

What excel version r u using

[@Asim._Arora]

Thanks 👍

[@krismohan3949]

Thank you for a very clear easy to follow video

[@lieutienentarslanbaloch662]

INFORMATIVE VIDEO

[@Namlenbalmuchu-]

Thanks sir❤

[@irfanchundavi3937]

very nice sir

[@monjerhaiyo6813]

Will the column year, month and days automatical adjust itself after 1 year?

[@excelcompletecourse]

If you used today Function in the formula it will update automatically

[@jawaharraj1]

Super good sir

[@krutagnapatel9548]

Thank you so much

[@prasantakutruka8990]

Fantastic

[@dmneelur9292]

Thanks

[@bristikonai6331]

❤

[@zaobsraccount2110]

THANKS, SIR

[@sidharth027]

Thanks bro

[@theankit2555]

Thanku bro

[@easymathsujitbiswas8356]

Very nice, 🇧🇩

[@abdulsajjadgalib]

Wow amazing 😎

[@bryonlim3183]

Thanks!

[@MJTube11]

You are welcome

[@s.smoters-bi1jw]

Sir aap simple bill practis bata sakte ho

[@Shafistudio]

thank you

[@pankajkumarsah6305]

Very helpful video
Thanks

[@bhanuchandercherukuri8523]

Thank🙏🙏

[@Brief_Knowledge_01]

Datedif formulae not available in my excel. What is alternative way to calculate age in date, month, day

[@udararathnayake8016]

highly recommended

[@shaonmusicseries6634]

so nice..

[@ishratramey5887]

Hi
kindly help me in this
23/02/2000 this is date of birth, what if I want to add 7 year and excel tell me 23/02/2007

[@kalivibes3098]

How did u automatically calculate the years following ?

[@alexjoy7363]

Thank you 🙏🏼

[@artipandey5772]

Thanku sir

[@aartiagrawal1936]

Tnqqq sir

[@canoeing9182]

GOOD SIR THANKS A LOT!!!!!!!!!!!!!!!!!!!!!

[@lvngclips01]

Tq sir

[@bossqueen6903]

Tq

[@byesudasnaik5919]

Wow 👍

[@chandrabowo6538]

Can you help me for repair error 1711 please?, I search this problem in any forum, but I can't find how to fix it. Please help me sir, thanks

[@rkchannel2183]

How to show Year and month both in a cell?

[@rupalimahulkar4548]

🙏🏻

[@arohisutar]

Nice information coments by smart aarohi youtube channel

[@NorhananRumaguia]

WHERE DID YOU GET THE NUMBER?

[@anonymous-bv8zl]

Why it's not working in my excel

[@zaveriyasiddiqui123]

Kisi kisi me chalta he bhai

[@FULLYFUNNYARMY]

Aap India se ho

[@spicy2602]

Not working in 2024. Datedif() function is not available in excel.

[@saquibahemad5518]

How to Withdrawal of 12 years from date of birth in excel

[@nabammanie7607]

15/2/2002 please calculate this... it's not happening with me

[@vannakr25]

you're de best!!!!

[@adilabbasi2718]

not working

[@Rktechnicalknowledge]

Good experience

[@sudeeppaul4377]

Datedif is not working in my excel 2010

[@theamazejkb]

In my case it shows #VALUE!

[@ravisontake4859]

Same column me kaise aayega sab yy mm dd

[@MdJewel-es8zo]

Plz janaben 8 months a year hobe ar formola ta ki

[@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? _

[@varinderspatwal]

Ho jayega..

[@kingveer3152]

Is there any body solve the question
Like ..
The person know only the year of birth
How could we know day and month
Is there any body help

[@tulikass4882]

It's showing me an error "value"

[@shelly7758]

Not working

[@belajena3612]

Plz give formula for if it is not calculated for "today"😢😢😢

[@excelcompletecourse]

You can simply do it by putting current date in double quotation " like this
=datedif(D4,"15-apr-2023","Y")

[@sarojkhamari8576]

Year ko date month year kese kare

[@nitikirti8029]

Njjj

[@abhinayamerugu4318]

0

[@nabammanie7607]

It's not working 😔

[@parasiteprem]

Noice

[@md.nasimreza6609]

It's not work

[@hjray2988]

Not coming

[@Epic_Sonia]

Getting #value error

[@MJTube11]

contact on fb facebook.com/mjtube11

[@nabammanie7607]

Nai ho rha hai bhai😭

[@roshanmaurya3277]

Date of birth nikalne par ##value## kyun लिख कर आता hai

[@mohdashfaque8813]

Year Rong hi