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

preview_player
Показать описание
How to Calculate Age from Date of Birth in MS Excel (Year, Month, Day)|
Excelमें जन्म तिथि से आयु की गणना कैसे करें

Formula: =DATEDIF(B4,C4,"y")&"years"&","&DATEDIF(B4,C4,"ym")&"months"&","&DATEDIF(B4,C4,"md")&"days"

How to Calculate Age from Date of Birth in MS Excel,how to calculate age in MS Excel,calculate age from date of birth,calculate year month day from date of birth,how to do age by date of birth,calculate age upto today from date of birth,formula from calculate the age,DATE OF BIRTH CALCULATE EXCEL,calculate age in excel,excel age calculation formula,how to calculate age in excel,how to calculate age with an excel formula,age calculation in excel,excel tutorial
Рекомендации по теме
Комментарии
Автор

Thanks for sharing your knowledge..
Useful and nice presentation

rhioroque
Автор

Thanks for the nice explanation. While calculating length of service, the result shows one day less.Please explain how to overcome it.

jalandhargouda
Автор

Up to months it is working after MD is not working..the days is not xoming😢

ajithkumar-fbcc
Автор

How to calculate exact age day year month without using DATEDIDF

rahulpawar
Автор

Sir aapne YM and MD kyooon likha jaise first time mein aapne only Y likha usi tarah kya sirf M ya D daalkar answer nahin aaa sakta tha ?? Please reply am waiting !!

ankurdhiman
Автор

Number of days one day less calculated sir

kashmirgill
Автор

DATE LIKHNE KE BAAD FORMULA LAGANE KE BAAD #VALUE! LIKH RAHA HAI, WHY?

omegacomputercenter