Formula for spanned months

[yee388]

I have two columns of dates:

1/1/06 --- 2/10/06
12/26/05 --- 3/25/06
8/27/05 --- 9/12/05

I want a formula for the number of months spanned.

so, for the above dates,

Jan, Feb = 2
Dec, Jan, Feb, Mar = 4
Aug, Sept = 2

Thanks!

 

[colbymack]

Does this work for you:
=((YEAR(E5)-YEAR(D5))*12)+MONTH(E5)-MONTH(D5)

Where E5 has the later date, and D5 has the earlier date.

 

[colbymack]

Sorry - you will want to add 1 at the end of that formula. I forgot that Dec to Mar =4, and not 3 (or 3.something)

 

[barry houdini]

perhaps

=IF(LEN(A1)*LEN(B1),DATEDIF(A1,B1,"m")+1+(DAY(A1)>DAY(B1)),"")

 

[yee388]

Perfect, colbymack. I love it when it's just that simple.

Barry, I haven't tried yours, but thanks for the effort.