Excels YEARFRAC function returns a decimal value which is the fractional years between two dates. B1-B236525 gives you the result as shown below. Calculate Age From ID Number In Excel.
The function can be used to calculate age in the other rows too.
You can also create an excel formula based on the INT function or ROUNDDOWN function the YEARFRAC function and the TODAY function to calculate age from birth of date. To find out the exact number of days or months see our tutorial on how to calculate the difference between two dates. TODAY -B2365 The first part of the formula TODAY -B2 returns the difference between the current date and date of birth is days and then you divide that number by 365 to get the numbers of years. Calculate Age In Years And Months And Days From Date Of Birth.