Ah, but with =A1-A2 the displayed result isn't a meaningful age - it's simply an Excel interpretation of the date equal to
31/12/1899 plus the difference between A1 & A2 (I acknowledge that Excel inherited the 1900 leap-year bug from Lotus with respect to
the treatment of dates before 1 March 1900).

You might get a more meaningful result with:
=DATEDIF(A1,A2,"y")&"/"&MOD(DATEDIF(A1,A2,"m"),12)

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Stefi" wrote in message ...
I'm not sure what chronological age and reading age are, but format hh:mm is
definitely NOT years and months but hours and minutes. Try to use format yy/mm
and formula =A1-A2 for the difference.
e.g. 10/01 - 08/5 will result 01/09.

Regards,
Stefi

€žJo€� ezt Ã*rta:

I have two columns: chronilogical age and reading age. I need to calculate
the difference between these ages. Age displayed as eg. 10:01 (10 years and
1 month) actual format is hh:mm.
Please can someone tell me the correct formula?
Thanks