Calculate a person's age from their date of birth in Excel.
Posted on 2013-05-29
Suppose a person's date of birth (DOB) is displayed in cell A1 (as a date format such as "mm/dd/yy"). What (non-VBA) formula in Excel will calculate and display the person's age in years?
I realize that the formula will somehow include the difference:
=TODAY() – DOB
but I am not quite sure what other functions to use and how to include them in the formula.
Also, Googling to various sites led to a couple of solutions which utilize the value 365.25 days per year (which is an approximation to account for leap year). However, I seem to remember seeing a solution in the past which does not include the approximation but calculates the answer directly. That's the formula I'm looking for.