Mike, Yes you are correct. .I am cornerd
And I dont know How to solve it. . . any help! .
Is it some leap year thing I am missing ?


"Mike H" wrote:

Claude,

be careful with your second formula and as en example try these 2 dates in
a1 and b1

31 Jan 1951
01 Mar 2008
which gives
57 years, 1 months, -1 days


Mike

"claude jerry" wrote:

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