Age Calculation

A

AGA

Oh great excel gurus,

I've read the threads on doing an age calculation, but I'm still getting a
"#NAME?" error. I need to display the age of dependents in months and years.
I've set up my columns so that column AI3 has the birthdate displayed as
10/29/2000, and column AJ3 has the formula =TODAY(). I tried to display the
age in column AK3 by inserting the following formula:

=DATEIF(AI3,AJ3,"Y") & "YEARS," & DATEIF(AI3,AJ3,"YM") & "Months," &
DATEIF(AI3,AJ3,"MD") & "Days"

Reagrdless of how I format the cell (general,number,text, etc) I still get
the same error. (I apologize in advance if the error is ridiculously obvious.
)

Thanks
AGA
 
M

Mike H

And when using this method look out for odd results


31 Jan 1951
01 Mar 2008
which gives
57 years, 1 months, -1 days

Mike
 
A

AGA

Ug, I'm an idiot.
Thank you for both the answer and not beating me over the head with it.
AGA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top