Hello,
I have an annual calendar of sales for each month. The months values are from F3 to Q3, and in A1 i have todays date.
I am using the following formula to calculate the maximum number between E3 and the sales of current month.
=MAX(E3;INDEX(F3:Q3;1;MONTH($A$1)))

I want to modify the range (F3:Q3) of this formula, and have a new range month by month. e.g. for F3,H3,J3,L3,N3 and P3.

Can anyone please help?