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