Reading Ages Conversion

[cosmica67]

Hi,

I used this forum successfully earlier this week so I hope someone can help me again with a solution to a problem I have.

I need a formula to convert 'Age at Test in Months' into 'Age at Test in YY:MM' so for example, 78 months will convert to and show 6/06 (6 Years and 6 Months) in the cell.

I would also like a formula to show the 'Reading Age Difference' in the same format. For example, in row 2 the 'Reading Age Difference' will be shown as 3/11 (3 years and 11 months) which is the difference between 6/06 and 10/05.


I have attached an excel spreadsheet in the hope that someone can help.

Thanks!

[Special-K]

Column E
=QUOTIENT(D2,12)&"/"&MOD(D2,12)

Column H
=QUOTIENT((HOUR(F2)*12+MINUTE(F2)-D2),12)&"/"&MOD((HOUR(F2)*12+MINUTE(F2)-D2),12)
and copy down

[cosmica67]

Hi Special-K,

Both formulae work a treat!

Also, many thanks for your prompt reply!

Kind regards