asked on

Calculate a person's age from their date of birth in Excel.

Hello,

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.

Thanks

Frosty555

How about YEARFRAC()?

http://office.microsoft.com/en-ca/excel-help/yearfrac-HP005209344.aspx

=YEARFRAC(TODAY(),A1)

(where "A1" is the cell containing the date of birth)

[ fanpages ]

Hi,

There is a discussion on date calculations within this recent thread:

"Excel formula that tells you the number of months" (20 May 2013)

[ https://www.experts-exchange.com/questions/28133886/Excel-formula-that-tells-you-the-number-of-months.html ]

BFN,

fp.

Steve

Using YEARFRAC and INT to give the age in whole years:
=INT(YEARFRAC(A1,TODAY()))

ASKER CERTIFIED SOLUTION

barry houdini

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Steve_Brady

ASKER

Thanks Barry.

[ fanpages ]

You're welcome, Steve_Brady.