Try this:

=IF(OFFSET(A7,0,1)=0,"",MONTH(OFFSET(A7,0,1))&DAY( OFFSET(A7,0,2)))

an offset of 0,1 is col. B and 0,2 is col. C of the same row as the
formula.

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=474178