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?