Calculate month difference between two dates

Hello,

I am trying to calculate the difference between two dates of different years and get the result in months..

i am using the following formula :

=(YEAR(LDate)-YEAR(EDate))*12+MONTH(LDate)-MONTH(EDate)

but the result i get is this :

10/2/1900 0:00

the result i need is in months! Hope will I do that? Anyone know?

I will really appreciate the help.. thanks..

Thanks mate...

I am wondering why didn't i think about it...

it worked just fine..

thanks again.

You could also get the same result with this formula

=DATEDIF(EDate-DAY(EDate)+1,LDate,"M")