Calculate age in years and month or decimal

H

HH

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top