I seemed to have figured it out...
=IF(I51="","",(YEAR(I51)-YEAR(H51))*12+MONTH(I51)-MONTH(H51)+1)
but if anyone sees why this may not work please let me know...thank you
--
speary
------------------------------------------------------------------------
speary's Profile:
http://www.excelforum.com/member.php...o&userid=24959
View this thread:
http://www.excelforum.com/showthread...hreadid=397218