Calculating an AGE

Question

Calculating an AGE

I want to create a field that automatically calculates someones age.
So I have a Date Of Birth field, and a Current Date field, plus a field that subtracts one from the other. The problem is it gives the answer in weeks (ie 2408 weeks.) How do it get it to give years and months?
Thanks!

Dual G5, Mac OS X (10.5.7)

Posted on Jun 3, 2009 7:59 AM

Reply

Answer 1

Best reply

Jerrold Green1

Level 7

30,210 points

Jun 3, 2009 8:24 AM in response to Andrew Stewart4

Hi Andrew,

The following expression will give you the years and months of age to the current date if the birth date is in Column A. You can make adjustments from there.

=INT(DATEDIF(A,TODAY(),"M")/12) & " Years and "&MOD(DATEDIF(A,TODAY(),"M"),12)&" Months"

Regards,

Jerry

Reply

Answer 2

Jun 3, 2009 10:11 AM in response to Jerrold Green1

Hi Jerry - thanks for that; you clearly know you're way round spreadsheets!
Can I ask you to make an amendment to your answer?
I don't always want to calculate the answer from todays date:
So...
Cell A1 = Date of birth
Cell B1 = Date (to be input)
Cell C1 = RESULT

Many thanks,
Andy

Reply