ExcelBanter - Converting months to years

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Converting months to years (https://www.excelbanter.com/excel-worksheet-functions/9514-converting-months-years.html)

kevin

Converting months to years

Hi, I used the nper function and the result is x months, what formula can i
use to convert that to x years, y months. simply dividing by 12 will give me
11.5 ie 11 and a half years. I want the answer to be 11 years, 6 months. any
ideas?

JE McGimpsey

One way:

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

In article ,
"kevin" wrote:

Hi, I used the nper function and the result is x months, what formula can i
use to convert that to x years, y months. simply dividing by 12 will give me
11.5 ie 11 and a half years. I want the answer to be 11 years, 6 months. any
ideas?

All times are GMT +1. The time now is 01:06 AM.