How can i record years and months

B

Bryan

I have a spreadsheet for childrens spelling ages. I need to be able to
record 9.2 as 9 years and two months. Can not work it out please help me.
 
F

Frank Kabel

Hi
maybe try
=INT(A1) & " years and " & MOD(A1,1)*10 & " months"

--
Regards
Frank Kabel
Frankfurt, Germany

Bryan said:
I have a spreadsheet for childrens spelling ages. I need to be able to
record 9.2 as 9 years and two months. Can not work it out please
Click to expand...
help me.
 
D

Dave Peterson

If you're going to do this, I think you'll want to use two decimal places.

9.02 (9 years, 2 months)

9.1 and 9.10 are the same number and you can have serious trouble separating
years from months.

Another option:

Enter the kid's birthdate and use a calculation to show the age:

With the date in A2:
=DATEDIF(A2,TODAY(),"y")&" Years "&DATEDIF(A2,TODAY(),"ym")&" Months"

You can find lots of information about =datedif() at Chip Pearson's site:
http://www.cpearson.com/excel/datedif.htm
 
Top