subtracting 2 dates and put the result in difference in months ?

[Susan]

I have dates in the format of 29-Jan-04 and need to work out the difference
from this date to another IN MONTHS

e.g.
25-Sep-95 to 29-Jan-04 = how many months?
Answer = 100 but need formula so i dont have to do it one by one - i have
thousands to do - please help?

 

[Mike H]

Hi,

With the earlier date in a1 try

=DATEDIF(A1,B1,"m")

datedif isn't documented in Excel so have a look here

http://www.cpearson.com/excel/datedif.htm

Mike

 

[Tom Hutchins]

If you want to see partial months (as a decimal value), you could use

=DAYS360(A1,B1)/30

To return whole months (rounding up), you could use

=ROUND(DAYS360(A1,B1)/30,0)

To return whole months (rounding down), you could use

=TRUNC(DAYS360(A1,B1)/30)

This last version gives the same results as DATEDIF, I believe.

Hope this helps,

Hutch