A3=end date
A2=start date

=MONTH(A3)-MONTH(A2)
Months between two dates in the same year


=(YEAR(A3)-YEAR(A2))*12+MONTH(A3)-MONTH(A2)
Months between two dates over a year apart


Hope it helps


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=496569