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

[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.

 

[Bob Umlas]

=INT(A1/12)&" years, "&A1-12*INT(A1/12)&" months."

Bob Umlas
Excel MVP

 

[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.

Kate,

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

regards

David

 

[Kate]

=INT(A1/12)&" years, "&A1-12*INT(A1/12)&" months."

Bob Umlas
Excel MVP






- Show quoted text -

Thank you so much!!!

 

[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)

 

[vbrown]

I actually need to go the other way. Can I convert 8 years 9 months into 105 months via a formula in excel?