Forulas

[Wayne Thompson]

I need to get a formula that will give me the age of a person on a data in the future, 4/30/2012. I have a DOB in one square and I need to know what his age will be on 4/30/12. In baseball a player can only be a certain age on 4/30/12. so if the kid was born on 3/1/03, I would like the forula to give me his age on 4/30/12. Can some one please help me? Thanks

 

[joeu2004]

I need to get a formula that will give me the age
of a person on a data in the future, 4/30/2012. I
have a DOB in one square and I need to know what
his age will be on 4/30/12. In baseball a player
can only be a certain age on 4/30/12. so if the
kid was born on 3/1/03, I would like the forula to
give me his age on 4/30/12.

If you only need the age to the year, use DATEDIF(...,"y"). For example, if
the DOB is in A1 and the date of evaluation (4/30/12 in your example) is in
A2, use:

=DATEDIF(A1,A2,"y")

Some people want the age in year, month and days. That is ill-advised,
IMHO, because it is subject to interpretation. But I'll forewarn you that
DATEDIF(...,"md") is defective in some revisions of XL2007 (SP1 and later).

 

[Cimjet]

Hi Wayne
Type this in an empty cell. with the DOB in A2 and future date in B2.
="Age is "&DATEDIF(A2,B2,"y")&" Years, "&DATEDIF(A2,B2,"ym")&" Months and
"&DATEDIF(A2,B2,"md")&" Days"
That's all one formula.
Cimjet

 

[Wayne Thompson]

Can I put the 4/30/12 date in the forula and not iin a cell?

 

[Cimjet]

Do it this way:
="Age is "&DATEDIF(A2,DATE(2012,4,30),"y")&" Years,
"&DATEDIF(A2,DATE(2012,4,30),"ym")&" Months and
"&DATEDIF(A2,DATE(2012,4,30),"md")&" Days"
Change A2 for the cell you want.
Cimjet

 

[Wayne Thompson]

Got it, I put 41029 in place of the B2 in my string.
41029 = 4/30/2012. It works, Thank You both.