How do I convert a number into years and months if the numberrepresents months?

K

Kate

How do I convert a number into years and months if the number
represents months?
Example: A formula to convert 105 Months to 8 Years and 9 months.
 
D

David Heaton

How do I convert a number into years and months if the number
represents months?
Example: A formula to convert 105 Months to 8 Years and 9 months.
Click to expand...


Kate,

=INT(105/12)&" years "&MOD(105,12) & " months"

regards

David
 
C

Chip Pearson

Another way

=TRUNC(A1/12)&" years "&MOD(A1,12)&" Years"

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Top