How to calculate someones age from today?

[Keith]

Using Excel what is the formula that I would use to
calculate someones age from today?

 

[Peo Sjoblom]

=DATEDIF(DOB,TODAY(),"Y")

for years

=DATEDIF(DOB,TODAY(),"Y")&" Year(s), "&DATEDIF(DOB,TODAY(),"YM")&" Month(s)
and "&
DATEDIF(DOB,TODAY(),"MD")&" Day(s)"

for years months and days



--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[papou]

Hello Keith
Assuming date of birth in A1
=DATEDIF(A1,TODAY(),""y"")

HTH
Cordially
Pascal

 

[Guest]

I am sorry I seem dense on this!
Here is what I have;
Column B I have 7/7/73 and in column C I want it to
calculate the age of the person from todays date without
having to enter todays date everytime I open the
worksheet. So if you could please type exactly what I am
suppose to put in I would appreciate it. Thanks, Keith

 

[Peo Sjoblom]

Replace DOB with your date

=DATEDIF(B1,TODAY(),"Y")&" Year(s), "&DATEDIF(B1,TODAY(),"YM")&" Month(s)
and "&
DATEDIF(B1,TODAY(),"MD")&" Day(s)"

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Don Guillett]

in c2 =DATEDIF(b2,TODAY(),"Y")
and COPY down (easiest with fill handle lower right of cell)