K
Keith
Using Excel what is the formula that I would use to
calculate someones age from today?
calculate someones age from today?
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.
P
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)
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)
P
papou
Hello Keith
Assuming date of birth in A1
=DATEDIF(A1,TODAY(),""y"")
HTH
Cordially
Pascal
Assuming date of birth in A1
=DATEDIF(A1,TODAY(),""y"")
HTH
Cordially
Pascal
G
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
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
P
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)
=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)
D
Don Guillett
in c2 =DATEDIF(b2,TODAY(),"Y")
and COPY down (easiest with fill handle lower right of cell)
and COPY down (easiest with fill handle lower right of cell)