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
--
Susan

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

=YEAR(B1)-YEAR(A1)

If this post helps click Yes
---------------
Jacob Skaria


"Susan Sia" wrote:

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
--
Susan

Oops..

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

This is also available in VBA as DATEDIFF()

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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

=YEAR(B1)-YEAR(A1)

If this post helps click Yes
---------------
Jacob Skaria


"Susan Sia" wrote:

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
--
Susan

Hi Susan

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

Hopes this helps.

---
Per

"Susan Sia" .(donotspam) skrev i meddelelsen
...
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
--
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



"Susan Sia" .(donotspam) skrev i ...



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
--
Susan- Ukryj cytowany tekst -

- Pokaż cytowany tekst -

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


"Jarek Kujawa" wrote:

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" .(donotspam) skrev i ...



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
--
Susan- Ukryj cytowany tekst -

- Pokaż cytowany tekst -

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" .(donotspam) skrev i meddelelsen
...
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


"Jarek Kujawa" wrote:

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" .(donotspam) skrev i
...



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
--
Susan- Ukryj cytowany tekst -

- Pokaż cytowany tekst -

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


On 16 Kwi, 13:15, Susan Sia .(donotspam) wrote:
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



"Jarek Kujawa" wrote:
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" .(donotspam) skrev i ...

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
--
Susan- Ukryj cytowany tekst -

- Pokaż cytowany tekst -- Ukryj cytowany tekst -

- Pokaż cytowany tekst -

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


"Jarek Kujawa" wrote:

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" .(donotspam) skrev i ...



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
--
Susan- Ukryj cytowany tekst -

- Pokaż cytowany tekst -

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
"Susan Sia" wrote:

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
--
Susan

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


"Susan Sia" wrote:

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
--
Susan

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 Sia" wrote:

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


"Susan Sia" wrote:

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
--
Susan

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

Regards
Ajay

"Ajax" wrote:

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 Sia" wrote:

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


"Susan Sia" wrote:

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
--
Susan

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

This is also available in VBA as DATEDIFF()

If this post helps click Yes
---------------
Jacob Skaria


"Susan Sia" wrote:

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
--
Susan