Hi Lights,
I'm not a big fan of adding text to the formula result because it stops you using that answer in another formula. I would possibly use the following formula:
=(MONTH(TODAY())+YEAR(TODAY())*12)-(MONTH(A1)+YEAR(A1)*12)
This will give you an integer (whole number) as a result. After that I would use a custom format to add the text that you want into the same cell as the formula.
After you enter the formula:
- go into format cells (Ctrl + 1)
- select the number tab
- choose custom (bottom of the list)
- in the type box, type: 0" mos"
- click OK
This will display at least 1 number and add " mos" after it and it won't break any formulas.