Calculate age

L

Luís Jorge

Hi

I need a function to calculate the age of a person starting on birthday.

Thank you

Luis Jorge
 
J

JulieD

Hi Luis
=DATEDIF(A1,B1,"y")+(B1-DATE(YEAR(A1)+DATEDIF(A1,B1,"y"),MONTH(A1),DAY(A1)))/(DATE(YEAR(A1)+DATEDIF(A1,B1,"y")+1,MONTH(A1),DAY(A1))-DATE(YEAR(A1)+DATEDIF(A1,B1,"y"),MONTH(A1),DAY(A1)))

where A1 is the birthdate and B1 the date that you want to calculate the
birthdate at - if you want to use the current date you can either put =NOW()
in B1 or change B1 in the formula to NOW()

Hope this helps

JulieD
 

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

Age calculator 1
Subtracting 2 dates 3
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
Giveaway Free copy of Age of Wonders III 2
SQL script to solve problem 1
Calculating a date 3
Summing unique values (where "unique" depends on multiple criteria") 4
Dynamic Date Calculation - Possible to create a formula showingMember Age, based on B'day 2

Top