Calculate age

[Susan Sia]

How can I calculate age accurately? If I put in the following two dates and
use the "Callculate the number of years between two dates" function, I get 26
as the answer, whereas the actual age is 25.

13/09/2003
09/04/2009

 

[Jacob Skaria]

A1 = start date
B1 = end date
Number of years is

=YEAR(B1)-YEAR(A1)

If this post helps click Yes

 

[Per Jessen]

Hi Susan

Just subtract the two dates and format the resulting cell as Custom "yy".

Hopes this helps.

 

[Mike H]

Hi,

Tr this

=DATEDIF(A1,A2,"y")

Datedif isn't documented in Excel so look here for help

http://www.cpearson.com/excel/datedif.aspx

Mike

 

[Jarek Kujawa]

with
A1=13/09/2003
A2=09/04/2009

you might use

=DATEDIF(A1,A2,"y")

DATEDIF is not described in HELP, "y" is for years, "m" for months,
"d" for days

BTW with given dates the correct result would be 5, not 25

 

[Susan Sia]

I do apologise to you and all who responded. The first date should have been
13/09/1983. This changes things slightly. Can you still help?

 

[Susan Sia]

I apologise to all. The first date should have been 13/09/1983. Can you
still help?

 

[Jacob Skaria]

Oops..

Use =DATEDIF(A1,A2,"y")

This is also available in VBA as DATEDIFF()

If this post helps click Yes

 

[Ajax]

Hi Sue

If Dates were A1(13/09/1983) and A2(09/04/2009) please use below formulae to
calculate age correctly.


=(YEAR(A2)-YEAR(A1))*12+MONTH(A2)-MONTH(A1)

Regards
Ajay

 

[Per Jessen]

Susan,

Either use the suggestion in my last post, or use the DateDif Function as
more people suggest. You will still get the desired result.

Best regards,
Per

I do apologise to you and all who responded. The first date should have
been
13/09/1983. This changes things slightly. Can you still help?

 

[Susan Sia]

Thank you so much - problem solved!!
--
Susan

with
A1=13/09/2003
A2=09/04/2009

you might use

=DATEDIF(A1,A2,"y")

DATEDIF is not described in HELP, "y" is for years, "m" for months,
"d" for days

BTW with given dates the correct result would be 5, not 25

 

[Ajax]

Apologies below formulae will calculate number of months and has to be
divided by 12 to get to age..

Regards
Ajay

 

[Jarek Kujawa]

my answer stays unchanged
use it or use Per's solution

 

[Jacob Skaria]

Use =DATEDIF(A1,A2,"y")

This is also available in VBA as DATEDIFF()

If this post helps click Yes