Error 509 when creating Dynamic Calender

[Allyoop]

Trying to Create a Dynamic Calendar. To display days of the month the following formula gives a 509 error.

=IF(MONTH({0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}E3-WEEKDAY(E3,1))=MONTH(E3),({0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}+E3-WEEKDAY(E3,1)),"") CTRL SHIFT ENTER
What am I doing wrong.

[cwolan]

Juxtapose the first and second arguments of your IF function:

MONTH({0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}E3-WEEKDAY(E3,1))=MONTH(E3),
     ({0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}+E3-WEEKDAY(E3,1))

In the second case, there is “+” operator after the inline array and before “E3”,

[erAck]

Also, positioning the cell cursor on the Err:509 cell the status line tells “Error: Operator missing”. It’s exactly that.