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
Пікірлер: 125
why this parenthesis color is red.... i insert this formula but not working.
It's not working 😔
not working
It's showing me an error "value"
15/2/2002 please calculate this... it's not happening with me
WHERE DID YOU GET THE NUMBER?
Thank you so much
Nice information coments by smart aarohi youtube channel
Plz give formula for if it is not calculated for "today"😢😢😢
Year Rong hi
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!!!💗💪
Thank you for sharing - Fantastic video
Thanks for this video
thank you for short and simple video but it helps a lot
Thanks for your information
Great Video! keep it up !!!
Thanks 👍 sir 😢😢🙏🙏🙏 aese hi video late rahie
Thanks for making this video
It's so help full thx
Thank you. It helped