Logical Function with months

[howard]

I have a month and year in A16 on sheet months


I am trying to set up a formula that if the month in A16 < April then return 0 , otherwise return 1, but it retruns 1

=IF(TEXT(Months!A16,"MMM")<"Apr",0,1)

It would be appreciated if someone could assist

 

[sheetspread]

Excel 2010
	A	B
1	April	1
Sheet8

Cell Formulas
Range	Formula
B1	=IF(MONTH(A1&1)<4,0,1)

works if just text

Excel 2010
	A	B
1	April 16	1
2	May 18	1
3	December 24	1
4	February 11	0
Sheet8

Cell Formulas
Range	Formula
B1	=IF(MONTH(A1)<4,0,1)

works with text and numbers

 

[howard]

Thanks for the help, much appreciated