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?
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?
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
Bruce
The older I get, the better I used to be.
USA
i get a '#value'
the cell is formated as 'general'
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks