Calculate age

  • Thread starter Thread starter Susan Sia
  • Start date Start date
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
 
A1 = start date
B1 = end date
Number of years is

=YEAR(B1)-YEAR(A1)

If this post helps click Yes
 
Hi Susan

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

Hopes this helps.
 
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
 
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?
 
Oops..

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

This is also available in VBA as DATEDIFF()

If this post helps click Yes
 
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
 
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?
Click to expand...
 
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
Click to expand...
 
Apologies below formulae will calculate number of months and has to be
divided by 12 to get to age..

Regards
Ajay
 
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

Similar Threads

Calculation of Age 3
How to count the occurrence? 3
How do count blank cells between some period of time? 4
Calculating When Somebody Reaches a Certain Age 4
calculate Age Year Month & day 3
Calculate age 3
Calculating age differences 6
How do I calculate a person's age from date of birth and a date 2

Back
Top