cell a7:=IF(B7=0,"",MONTH(C7)&DAY(C7))

when i select b7:h7 and 'insert, shift rows down' the fromula changes
in a7 to =IF(B8=0,"",MONTH(C8)&DAY(C8))

How con I do this without a change to a7?


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

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

i get a '#value'
the cell is formated as 'general'


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

My guess is that you have a text entry in either B or C, not a number
that can be used to calculate a MONTH or a DAY...hence the #VALUE error
that Excel returns when trying to do date calculations on non-valid date
values.

Good Luck


--
swatsp0p


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