calculate age using current date and DOB

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I am using Excel 2003, I need to calculate the age of
individuals as of 12/31/03. Is there a formula or
function that can calculate the age as of 12/31/03?

I have tried the dateif function, it does not work in
2003.

Any assistance will be greatly appreciated.
 
=DATEDIF(dob,end date,"Y")

dob in A1 and 12/31/03 in B1

=DATEDIF(A1,B1,"Y") years

=DATEDIF(A1,B1,"YM") months after years are counted

=DATEDIF(A1,B1,"MD") days after months are counted
 
Joe said:
I am using Excel 2003, I need to calculate the age of
individuals as of 12/31/03. Is there a formula or
function that can calculate the age as of 12/31/03?
Click to expand...


try this:
With 12/31/03 in A1


=DATEDIF(NOW(),A1,"y")&" years, "&DATEDIF(NOW(),A1,"ym")&" months,
"&DATEDIF(NOW(),A1,"md")&" days"
 
Disregard my earlier post; try this instead:

dob in A1, 12/31/03 in B1

=DATEDIF(A1,B1,"y") & " y " & DATEDIF(A1,B1,"ym") & " m " & DATEDIF(A1,B1,"md")&"d"
 
Back
Top