R
Rookie
How can I calculate a persons age from a birthdate in excel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JudithJubilee
This is a quick way but not the best:
If you put the birthdate in A1:
=(TODAY()-A1)/365
You will need to format the cell with General formatting.
Judith
If you put the birthdate in A1:
=(TODAY()-A1)/365
You will need to format the cell with General formatting.
Judith
G
Guest
HI,
=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW
(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days"
From Chip Pearson's site:
http://www.cpearson.com/excel/datedif.htm#Age
=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW
(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days"
From Chip Pearson's site:
http://www.cpearson.com/excel/datedif.htm#Age
L
Llobid
Just read this one in another post...
Try:
=DATEDIF(A1,Today(),"y"
Try:
=DATEDIF(A1,Today(),"y"
R
Rookie
Datedif did the trick. Thanks to all