Age calculator Template in Excel - Find the exact age of a person in Years, months and days in Excel
Excel Is Simple
calculate agecalculate age from date of birthcalculate age from date of birth in excelcalculate age in excelcalculate age in excel 2016calculate age using datedif functiondatedifdatedif function in excel 2010datedif function in excel 2013datedif function in excel 2016datediffexcelexcel basicsexcel for beginnersexcel formulasexcel tutorialexcel tutorial for beginnerseducation
Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1
Using DATEDIF function, the calculation of age from date of birth is quick and easy. This can make an easy and handy age calculator in excel.
Lets say your date of birth is in the cell B10, then the function to calculate the age will be:
=DATEDIF(B10,NOW(),"Y") This will give you the age in Years
=DATEDIF(B10,NOW(),"Y")&" Years "&DATEDIF(B10,NOW(),"YM")&" Months "&DATEDIF(B10,NOW(),"MD")&" Days" ... https://www.youtube.com/watch?v=mUYarKQzeyo
2019-07-10
0.0 LBC
Copyrighted (contact publisher)
50654942 Bytes