getting year and month from two dates

[Sheepkin_Coat]

Hi

i have a date in column a and a date in column b like this 01/10/2010 english way

how can i find out how many years between to dates also months

[Richard Buttrey]

Hi,

For Years: in C1
=YEAR(B1)-YEAR(A1)

for months: in D1
=MONTH(B1)-MONTH(A1)+C1*12

You may wish to adjust for boundary conditions if relevant.

Regards