How to calculate age as of a certain date 3

[loveyoursite]

I've searched this forum and did not see exactly what I'm looking for. I need a formula that will give me someone's age in years as of a certain date. For example, for a birthdate of 8/26/1958, the age as of 1/1/2006 is 47 and the age as of 1/1/2007 is 48. Thanks!

 

[GlennUK]

Try DATEDIF function. Like this:

=DATEDIF("8/26/58","1/1/2006","y")

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[xlhelp]

=DATEDIF(Date1(earlier),Date2(latter),"y")



Me transmitte sursum, Caledoni!

 

[SkipVought]

Hi,

Check out the TODAY function. calculate the difference between today and the date. The answer will be in DAYS. Divide by 365 to get years. You might want to use the INT function to return the INTEGER part of the division.





Skip,

_[red][/red]

 

[xlhelp]

Hi, Skip.

If this was for insurance purpose or similar, anyone born up to 16th January (dividing by 365) will add a year (depending on how long a period) . You wouldn't want to pay a higher insurance premium just because you fall into a higher age band.

Me transmitte sursum, Caledoni!

 

[loveyoursite]

Thank you all so much! Now that I have that solved, I have one more need - I'll post another. Thanks again!

 

[firefytr]

There is the formula that OzGrid has had up for a while which extends it a little bit, assuming A1 houses the date in question ..

=DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months, " & DATEDIF(A1,TODAY(),"MD") & " Days"

.. or ..

=DATEDIF(A1,TODAY,"Y") & " Years, " & DATEDIF(A1,TODAY,"YM") & " Months, " & DATEDIF(A1,TODAY,"MD") & " Days"

Found here.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci