I understand...Try this regular formula:
C4: =MAX(D4;INDEX(F4:AB4;MONTH($A$1)*2-1))
Does that help?