Before date IF statement

[Craig1]

Guys,
Can anyone tell me what is wrong with this IF statement.

All I want to do is in cell G3 I need a "In Date" or "Out of Date" based on the date in E3.

=IF($E3="<01/07/2008","In date","Out of Date")

So if E3 is before 01/07/2008 it is out of date and after 01/07/2008 it is in date.

Thanks in advance.

Craig.

 

[CharlesChuckieCharles]

=IF($E3<=DATEVALUE("1/7/2008"),"In date","Out of Date")

or =IF($E3<=F1,"In date","Out of Date")

where F1 = 01/07/2008

 

[yogeshmaney]

=IF($E3<=DATE(2008,7,1),"In date","Out of Date")

 

[Craig1]

Thanks guys, it works perfect.

Your is appreciated.

Craig.