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

[@RakeshvlogsJH]

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

[@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!!!💗💪

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

[@BhagvaankeBhakt]

Very fantastic

[@Shriradhekrishna001.]

It's so help full thx

[@sarajonikishan5669]

Thank you sir🙏🙏👍

[@lanphiliparenque1843]

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

[@jondas2272]

Thanks sir.

[@MrJaipaul1]

U saved me lot of time

[@maheshwaradatta1587]

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

[@Curiousbandaa]

Thanks for making this video

[@PradeepKumar-ej9xo]

Thanks for this video

[@gouravbeniwal2137]

Wow Very helpfull video sir

[@dilipkumardas7251]

It's very easy and simple

[@sabinasdream3307]

Very helpful

[@s.smoters-bi1jw]

Thanks sir

[@rohitverma7160]

Thanks for your information

[@rinatiriya6524]

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

[@prasantakutruka8990]

You made my day

[@lieutienentarslanbaloch662]

INFORMATIVE VIDEO

[@KAAMKIBAATAIN]

Thank you. It helped

[@rohitmewada3455]

thank you so much 😀

[@itsgauravrajput6108]

Tq for this video

[@shakshisingh5609]

Thank you so sir❤😊

[@TrusteestDesiChhora]

Thanks sar 💯❤️

[@marceljunioregondi5594]

This just made my work a whole lot easier.

[@mansoorusman883]

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

[@irfanchundavi3937]

very nice sir

[@vijayrajendhiran7223]

Thanks 3

[@krismohan3949]

Thank you for a very clear easy to follow video

[@Asim._Arora]

Thanks 👍

[@jawaharraj1]

Super good sir

[@atulgupta77]

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

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

[@Namlenbalmuchu-]

Thanks sir❤

[@easymathsujitbiswas8356]

Very nice, 🇧🇩

[@AmitChandra_YouTube]

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

[@prasantakutruka8990]

Fantastic

[@sidharth027]

Thanks bro

[@zaobsraccount2110]

THANKS, SIR

[@fruityslathia995]

Thanks alot sir

[@pankajkumarsah6305]

Very helpful video
Thanks

[@annamalaisuresh6235]

Thank you sir

[@bryonlim3183]

Thanks!

[@MJTube11]

You are welcome

[@udararathnayake8016]

highly recommended

[@s.smoters-bi1jw]

Sir aap simple bill practis bata sakte ho

[@rjh1394]

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

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

[@Shafistudio]

thank you

[@abdulsajjadgalib]

Wow amazing 😎

[@kashifmumtaz007]

Thank you for sharing - Fantastic video

[@grammenelectric9800]

Thanks

[@adilabbasi2718]

not working

[@arohisutar]

Nice information coments by smart aarohi youtube channel

[@anonymous-bv8zl]

Why it's not working in my excel

[@zaveriyasiddiqui123]

Kisi kisi me chalta he bhai

[@bhanuchandercherukuri8523]

Thank🙏🙏

[@theankit2555]

Thanku bro

[@shaonmusicseries6634]

so nice..

[@NitaFunnyVideo]

What excel version r u using

[@artipandey5772]

Thanku sir

[@Brief_Knowledge_01]

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

[@aartiagrawal1936]

Tnqqq sir

[@spicy2602]

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

[@krutagnapatel9548]

Thank you so much

[@bossqueen6903]

Tq

[@kalivibes3098]

How did u automatically calculate the years following ?

[@byesudasnaik5919]

Wow 👍

[@puranyashkapoor7468]

Great Video! keep it up !!!

[@NorhananRumaguia]

WHERE DID YOU GET THE NUMBER?

[@vannakr25]

you're de best!!!!

[@rkchannel2183]

How to show Year and month both in a cell?

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

[@nabammanie7607]

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

[@bristikonai6331]

❤

[@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")

[@canoeing9182]

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

[@lvngclips01]

Tq sir

[@theamazejkb]

In my case it shows #VALUE!

[@FULLYFUNNYARMY]

Aap India se ho

[@saquibahemad5518]

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

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

[@Pakstarop-q5c]

ITS GIVING VALUE ERROR PLZ HELP

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

[@sudeeppaul4377]

Datedif is not working in my excel 2010

[@rupalimahulkar4548]

🙏🏻

[@MdJewel-es8zo]

Plz janaben 8 months a year hobe ar formola ta ki

[@alexjoy7363]

Thank you 🙏🏼

[@ravisontake4859]

Same column me kaise aayega sab yy mm dd

[@Rktechnicalknowledge]

Good experience

[@roshanmaurya3277]

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

[@sarojkhamari8576]

Year ko date month year kese kare

[@nabammanie7607]

It's not working 😔

[@nabammanie7607]

Nai ho rha hai bhai😭

[@Epic_Sonia]

Getting #value error

[@MJTube11]

contact on fb facebook.com/mjtube11

[@hjray2988]

Not coming

[@neetugupta4696]

Sir Hindi me bataiye yahi

[@md.nasimreza6609]

It's not work

[@nitikirti8029]

Njjj

[@amankitech6160]

Mc hindi bolo😂