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!
Bookmarks