IF MONTH STATEMENT WITH MULTIPLE VALID OPTIONS

[Ronboy]

I'm trying to construct an IF statement based on the MONTH where there can be multiple valid months.
I currently have the following statement which works, but I'd like to find a more compact alternative:
IF(OR(MONTH(A1)=4,MONTH((A1)=7,MONTH(A1)=9,MONTH(A1)=11),1,0)
Perhaps something like the following (which I could not get working):
IF(MONTH(A1)={4,7,9,11},1,0)
Any help would be greatly appreciated.

 

[Phuoc]

=IF(Or(MONTH(A1)={4,7,9,11}),1,0)

 

[Ronboy]

=IF(Or(MONTH(A1)={4,7,9,11}),1,0)

Thanks! And if I wanted to store that list of months in a single cell (A2) which I could then reference in your IF statement, how would I go about doing that?

 

[Phuoc]

Random_rows.xlsm
	A
1	02/02/2022
2	1,4,7,11,12
3	0
4	0
Sheet1

Cell Formulas
Range	Formula
A3	A3	=IF(ISNUMBER(FIND(","&MONTH(A1)&",",","&A2&",")),1,0)
A4	A4	=COUNT(FIND(","&MONTH(A1)&",",","&A2&","))

 

[Ronboy]

Random_rows.xlsm
	A
1	02/02/2022
2	1,4,7,11,12
3	0
4	0
Sheet1

Cell Formulas
Range	Formula
A3	A3	=IF(ISNUMBER(FIND(","&MONTH(A1)&",",","&A2&",")),1,0)
A4	A4	=COUNT(FIND(","&MONTH(A1)&",",","&A2&","))

That doesn't sound helpful. What I was hoping for what something like:
=IF(OR(MONTH(A1)=A2),1,0) where A2 contained {4,7,9,11} in some form.

 

[Phuoc]

The value in A2 is a string, not an array, so it doesn't work.

 

[Ronboy]

The value in A2 is a string, not an array, so it doesn't work.

I see. Is there a straightforward way to express it as an array in A2?