Convert months to months and years

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

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?

Originally Posted by Alfry

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?

Ideally the result would be in one cell but evern if i had two cells with the number of years and another with the number of months I could join them together