Calculate age
 

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

Calculate age
 

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

Calculate age
 

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

Calculate age
 

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

Calculate age
 

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 -

Calculate age
 

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 -

Calculate age
 

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

Calculate age
 

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

Calculate age
 

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

Calculate age
 

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 -

Calculate age
 

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 -

Calculate age
 

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

Calculate age
 

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 -

Calculate age
 

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