How do I calculate age using dates in Excel?

G

Guest

The formula I found in Excel Help to calculate the number of years between 2
dates is only accurate if the birthday has passed for this year. For example
-
03/24/1974 - 10/01/2004 = 30
10/24/1974 - 10/01/2004 = 30 - This is wrong the person is still 29 years of
age.
 
A

Art in Carlisle PA

Clumsy, but it should work as a formula in a cell:

A1 is earliest date, B1 is latest date:

IF(B1-Date(Year(B1),"1","1")
<
A1-Date(Year(A1),"1","1"),
Year(B1)-Year(A1)-1,
Year(B1)-Year(A1))

Blessings in abundance, all the best, and ENJOY!

Art Du Rea Carlisle, PA USA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I calculate a person's age on a specific date? (huge roster 2
Excel Average dates help 0
Calculating Date of next birthday 3
Calculate age 5
How do I calculate a persn's age in years & months in Excel? 4
How do I find age in years from anniversary date (Age funtion)? 1
Can you calculate the number of years between two dates in Excel 0 4
"how do I calculate age by using date of birth details" 5

Top