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




About this tutorial:

Video duration: 00:03:32
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 :
Follow on twitter:
Website :

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads