Calculate age

S

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
 
J

Jacob Skaria

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

=YEAR(B1)-YEAR(A1)

If this post helps click Yes
 
P

Per Jessen

Hi Susan

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

Hopes this helps.
 
J

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
 
S

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?
 
S

Susan Sia

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

Jacob Skaria

Oops..

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

This is also available in VBA as DATEDIFF()

If this post helps click Yes
 
A

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
 
P

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

Susan Sia said:
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?
 
S

Susan Sia

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


Jarek Kujawa said:
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
 
A

Ajax

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

Regards
Ajay
 
J

Jacob Skaria

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

This is also available in VBA as DATEDIFF()

If this post helps click Yes
 

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

Top