Calculating current age from 2 date cells

[dhealy]

I have 2 cells, one with date of birth and one with current date. I am
trying to get the current age to calcualate using these two fields....any
suggestions?

 

[JulieD]

Hi

you can use the datedif function to do this:

with the birthdate in A1 and the date you're interested in in B1
=DATEDIF(A1,B1,"y") & " years, " & DATEDIF(A1,B1,"ym") & " months, " &
DATEDIF(A1,B1,"md") & " days"

if you want to use the current date you don't need to have it in another
cell you can use the NOW function, e.g.
=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " &
DATEDIF(A1,NOW(),"md") & " days"

for more details check out
http://www.cpearson.com/excel/datedif.htm#Age

Cheers
JulieD