Calculating age
A1 = birth date
B1 = Today()
in C1 enter this = =DATEDIF(A1,B1,"Y")
for more detailed age try this
=DATEDIF(A1,B1,"Y")&" Years "&DATEDIF(A1,B1,"YM")&" Months
"&DATEDIF(A1,B1,"MD")&" Days"
"Pascale" wrote:
Could you please tell me how I could have in column C, the age of a person
from indicating (column A)the birthdate and the other (column B) today's
date. Many thanks ahead
|