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?

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?
>
>
>

Thanks,
Just what I needed.

"Gary''s Student" <(E-Mail Removed)> wrote in message
news:3D16EE76-3071-4FF8-A9B0-(E-Mail Removed)...
> 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?
>>
>>
>>