years and months

[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

 

[A.W.J. Ales]

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 *

 

[Don Guillett]

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"

 

[jim]

That is absolutely brilliant i am impressed thank you so much
jim

 

[Don Guillett]

Hey, I'll take the thanks for posting but I didn't create that formula. I
think it is Chip Pearsons.
glad to help

 

[Dave Peterson]

I don't think =datedif() has been part of the analysis toolpak for a long time
(xl4???)

But some more info for the OP:
http://www.cpearson.com/excel/datedif.htm

 

[Don Guillett]

I guess I was thinking of the not being available in help.