Quote Originally Posted by teeb
in cell A1 i have a number of months. What I want to do is convert this into years and months.

ie 14 = 1 year 2 months.

Any help would be appreciated.

Cheers
Do you need it as a macro which implements 2 cells (say, Years=A2 and Months=A3) or as a couple of cells in which are directly shown the equivalent numers of years and months?