Average Formula for unconventional Data

Hi,

I am trying to average some data but the data is in an unconventional format.

The format is Years/Months and is shown like this example:

7/5 would be 7 Years and 5 Months

10/11 would be 10 Years and 11 months

Some of the data will be blank as well so I need to account for any blank cells. So cell C5 will have an average of 6/2

The average result cells C2:C7 need to be in the same format as the cells it is calculating, so 7/2, for example.

I have attached a sample file. I am using Excel 2016.

Thanks for looking.

You haven't filled the average column wth manually calculated results - we need to know exactly what you are expecting,

Are you wanting to average the Y/M in one column, or both? Or to get the average of the difference between col A and col B?? or what??

Please try

PHP Code: 

=SUBSTITUTE(TEXT(DOLLARFR(SUMPRODUCT(TEXT(MID(SUBSTITUTE(A2:B2,"/","   "),{1;4},3),"0;;;\0")*{12;1})/COUNTA(A2:B2)/12,12)*100,"0\/00"),"/0","/")