Convert # of months into Years and Months

[vanhalen5_2000]

If I have a cell that has a number, say 59. I would like to convert that in another cell into years and months, for example 59 months would equal 4 years 11 months. Is there a way to display that as 4.11
Thanks

 

[sassy1177]

Old thread but hoping to get some help. I've calculated tenure by individual groups. Now I want to have an average for each group and place into a pivot or chart; however, when I use the above I am getting this result: 2 Years and 10.2142857142857 Months

Is there a way to round this to just years/months?

 

[Dave Patton]

You could start a new thread.
Describe what you are require and show a few examples of expected results.

You may want to look at function YearFrac or Datedif for months.

N.B. Datedif still works; it just does not show as a regular function.