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..