View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
HH[_4_] HH[_4_] is offline
external usenet poster
 
Posts: 42
Default Calculate age in years and month or decimal

Thanks,
Just what I needed.

"Gary''s Student" wrote in message
...
http://www.cpearson.com/excel/datedif.aspx
--
Gary''s Student - gsnu2007j


"HH" wrote:

I use =INT((TODAY()-D9)/365.25) to calculate the age of a person. No one
is
under 8 years old so it works fine. The answer is given in years.

I want the answer to be give as a decimal (i.e. 14.3). Another request
is
to have the answer years and months (16 years, 2 months)

How can I get either or both of these done?