View Single Post
  #2   Report Post  
speary
 
Posts: n/a
Default


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