How do I put in a formula in Exel to calculate a persons age?
 

I have a formula in for someones age but it shows me their age that they will
be this year. How do I get it so it shows the correct age and then changes on
their birthday.

How do I put in a formula in Exel to calculate a persons age?
 

See this. Scroll down near the bottom of this page:

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

--
Biff
Microsoft Excel MVP


"boofire19" wrote in message
...
I have a formula in for someones age but it shows me their age that they
will
be this year. How do I get it so it shows the correct age and then changes
on
their birthday.

How do I put in a formula in Exel to calculate a persons age?
 

=DATEDIF(A1,TODAY(),"y") & " years old"

Assumes birthdate in A1

If you want a more detailed message............

=DATEDIF(A1,TODAY(),"y") & " years," & DATEDIF(A1,TODAY(),"ym") & "
months,"& DATEDIF(A1,TODAY(),"md") & " days old"


Gord Dibben MS Excel MVP

On Thu, 18 Feb 2010 13:31:01 -0800, boofire19
wrote:

I have a formula in for someones age but it shows me their age that they will
be this year. How do I get it so it shows the correct age and then changes on
their birthday.

How do I put in a formula in Exel to calculate a persons age?
 

Hi,

There is a problem with the DATEDIF() with an md. In cell A13, type
31/7/2007 I.e. 31 July 2007. In cell B13, type 02/03/2009 I.e. 2 March
2009. The following formula in Excel 2007, yields -1 (minus 1) as the
answer

=DATEDIF($A13,$B13,"md")

I work around it by using =B13-EDATE(A13,(C13*12)+D13)

C13 has DATEDIF($A13,$B13,"y");
D13 has DATEDIF($A13,$B13,"ym")

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
=DATEDIF(A1,TODAY(),"y") & " years old"

Assumes birthdate in A1

If you want a more detailed message............

=DATEDIF(A1,TODAY(),"y") & " years," & DATEDIF(A1,TODAY(),"ym") & "
months,"& DATEDIF(A1,TODAY(),"md") & " days old"


Gord Dibben MS Excel MVP

On Thu, 18 Feb 2010 13:31:01 -0800, boofire19
wrote:

I have a formula in for someones age but it shows me their age that they
will
be this year. How do I get it so it shows the correct age and then changes
on
their birthday.

How do I put in a formula in Exel to calculate a persons age?
 

=CONCATENATE("This person is ",(DATEDIF(A1,TODAY(),"y") & " years, " &
DATEDIF(A1,TODAY(),"ym") & "months, "& DATEDIF(A1,TODAY(),"md") & " days
old"))


It is yours with the addition of "This person is..." as a prefix.



On Thu, 18 Feb 2010 14:02:37 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

=DATEDIF(A1,TODAY(),"y") & " years old"

Assumes birthdate in A1

If you want a more detailed message............

=DATEDIF(A1,TODAY(),"y") & " years," & DATEDIF(A1,TODAY(),"ym") & "
months,"& DATEDIF(A1,TODAY(),"md") & " days old"


Gord Dibben MS Excel MVP

On Thu, 18 Feb 2010 13:31:01 -0800, boofire19
wrote:

I have a formula in for someones age but it shows me their age that they will
be this year. How do I get it so it shows the correct age and then changes on
their birthday.

How do I put in a formula in Exel to calculate a persons age?
 

Do they have any intention of fixing it?



On Sat, 20 Feb 2010 11:46:09 +0530, "Ashish Mathur"
wrote:

Hi,

There is a problem with the DATEDIF() with an md. In cell A13, type
31/7/2007 I.e. 31 July 2007. In cell B13, type 02/03/2009 I.e. 2 March
2009. The following formula in Excel 2007, yields -1 (minus 1) as the
answer

=DATEDIF($A13,$B13,"md")

I work around it by using =B13-EDATE(A13,(C13*12)+D13)

C13 has DATEDIF($A13,$B13,"y");
D13 has DATEDIF($A13,$B13,"ym")

Hope this helps.

How do I put in a formula in Exel to calculate a persons age?
 

Why can I not find "DATEDIF" in the function reference in the help file?



On Sun, 21 Feb 2010 13:38:55 -0800, CellShocked
<cellshocked@thecellvalueattheendofthespreadsheet. org wrote:

Do they have any intention of fixing it?



On Sat, 20 Feb 2010 11:46:09 +0530, "Ashish Mathur"
wrote:

Hi,

There is a problem with the DATEDIF() with an md. In cell A13, type
31/7/2007 I.e. 31 July 2007. In cell B13, type 02/03/2009 I.e. 2 March
2009. The following formula in Excel 2007, yields -1 (minus 1) as the
answer

=DATEDIF($A13,$B13,"md")

I work around it by using =B13-EDATE(A13,(C13*12)+D13)

C13 has DATEDIF($A13,$B13,"y");
D13 has DATEDIF($A13,$B13,"ym")

Hope this helps.

How do I put in a formula in Exel to calculate a persons age?
 

Why can I not find "DATEDIF" in the function
reference in the help file?

Read the first paragraph on this page:

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

--
Biff
Microsoft Excel MVP


"Lil Red Riding In The Hood"
<lilredridinginthehood@grandmashouseattheendoftheu niverse.org wrote in
message ...
Why can I not find "DATEDIF" in the function reference in the help file?



On Sun, 21 Feb 2010 13:38:55 -0800, CellShocked
<cellshocked@thecellvalueattheendofthespreadsheet. org wrote:

Do they have any intention of fixing it?



On Sat, 20 Feb 2010 11:46:09 +0530, "Ashish Mathur"
wrote:

Hi,

There is a problem with the DATEDIF() with an md. In cell A13, type
31/7/2007 I.e. 31 July 2007. In cell B13, type 02/03/2009 I.e. 2 March
2009. The following formula in Excel 2007, yields -1 (minus 1) as the
answer

=DATEDIF($A13,$B13,"md")

I work around it by using =B13-EDATE(A13,(C13*12)+D13)

C13 has DATEDIF($A13,$B13,"y");
D13 has DATEDIF($A13,$B13,"ym")

Hope this helps.

How do I put in a formula in Exel to calculate a persons age?
 

No

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"CellShocked" <cellshocked@thecellvalueattheendofthespreadsheet. org wrote
in message ...
Do they have any intention of fixing it?



On Sat, 20 Feb 2010 11:46:09 +0530, "Ashish Mathur"
wrote:

Hi,

There is a problem with the DATEDIF() with an md. In cell A13, type
31/7/2007 I.e. 31 July 2007. In cell B13, type 02/03/2009 I.e. 2 March
2009. The following formula in Excel 2007, yields -1 (minus 1) as the
answer

=DATEDIF($A13,$B13,"md")

I work around it by using =B13-EDATE(A13,(C13*12)+D13)

C13 has DATEDIF($A13,$B13,"y");
D13 has DATEDIF($A13,$B13,"ym")

Hope this helps.

How do I put in a formula in Exel to calculate a persons age?
 

On Sun, 21 Feb 2010 21:30:46 -0500, "T. Valko"
wrote:

Why can I not find "DATEDIF" in the function
reference in the help file?

Read the first paragraph on this page:

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


Thank you. That is perfect.

How do I put in a formula in Exel to calculate a persons age?
 

On Mon, 22 Feb 2010 08:34:26 +0530, "Ashish Mathur"
wrote:

No


Well, that was SUCK-sinct!

How do I put in a formula in Exel to calculate a persons age?
 

If you have the Analysis Toolpack add-in (Tools menu, choose Add-ins and
check Analysis toolpack) you can also use

=INT(DAYS360(birthdate,TODAY())/360)

"boofire19" wrote:

I have a formula in for someones age but it shows me their age that they will
be this year. How do I get it so it shows the correct age and then changes on
their birthday.