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

  • Thread starter Thread starter Kate
  • Start date Start date
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.
 
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
 
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)
 
I actually need to go the other way. Can I convert 8 years 9 months into 105 months via a formula in excel?
 
Back
Top