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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks