Calculating a persons age in Excel

[Col]

Hi all,

In Excel is it possible to calculate a persons age.

I have at the moment their birthdate in cell A2 and the Today() formula in

B2 and have done B2-A2.

It doesn't work, even formatting the cell incorporating the [h] format to
change it to hours then dividing by 24 then 365 doesn't give the correct
result either.

Anyone have any ideas.

Many thanks for any help.

Colin.

 

[Arvi Laanemets]

Hi

=DATEDIF(A2,TODAY(),"Y") & " years " & DATEDIF(A2,TODAY(),"YM") & " months "
& DATEDIF(A2,TODAY(),"MD") & " days"

 

[windsurferLA]

You have the right idea, but possible error in formula.

Formula =(B2-A2)

gives time between the two events in days. Use general formating to
show days rather than a date. Dividing by 365.25 yields age in years as
a decimal.

Formula = (B2 - A2) * 24 yields age in hours as a decimal.

If formula is not working, make sure dates are entered as numbers and
not as characters.

WindsurferLA

 

[Col]

Thank you Arvi, worked perfectly plus the main point is now I understand why
it works.

Thanks again.

Colin.

 

[Arvi Laanemets]

You are welcome!