How convert an integer into years and months if the number represents months and days

[fayez_MrExcel]

in my recent query id like to convert an integer into years and months if the number represents months and days. Example 143.67 (where 143 is a month and .67 is days)

 

[Fluff]

Duplicate to: Calculating months based on Balance amount vs monthly deduction

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.