years and months

  • Thread starter Thread starter jim
  • Start date Start date
J

jim

Is it possible to have a date of birth and a current date and therefore work
out the age of the person in years and months. If I divide the number by
365 it will give the years and the percentage of the last year ie 7.9 will
not be 7 and 9 months but 7 and .9 of a full year. Thanks in advance.
Jim
 
Jim,

For the age in years : DATEDIF(Birthdate,Current date,"y")

For the rest in months : MOD(DATEDIF(Birthdate,Current date,"m"),12)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
try this where you have the analysis toolpak addin installed and d2 has a
date before today. ONE line

=DATEDIF(D2,TODAY(),"y") & " years, " & DATEDIF(D2,TODAY(),"ym") & " months,
" &DATEDIF(D2,TODAY(),"md") & " days"
 
Hey, I'll take the thanks for posting but I didn't create that formula. I
think it is Chip Pearsons.
glad to help
 
Back
Top