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

Replace
DATEIF
with
DATEDIF
--
Gary''s Student - gsnu200847


"AGA" wrote:

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

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


"AGA" wrote:

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

Thanks,will do

"Mike H" wrote:

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


"AGA" wrote:

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

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

"Gary''s Student" wrote:

Replace
DATEIF
with
DATEDIF
--
Gary''s Student - gsnu200847


"AGA" wrote:

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