Find max number of current month.

[v!ctor]

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?

[Ron Coderre]

Does this regular formula do what you want?

Please Login or Register  to view this content.

[v!ctor]

Thanks for the help

I think its not working

Please find attached file

In C4 I want maximum number between ''qty per day'' of current month (F4,H4,J4,L4,N4,P4,R4,T4,V4,X4,Z4 and AB4) and D4.

[Ron Coderre]

I understand...Try this regular formula:

Please Login or Register  to view this content.

Does that help?

[v!ctor]

Yes!! It works perfect
Thank you...