Hi Gemz

Try following

Sub checkdate()
If DateValue(Cells(3, 5).Value) < "03/03/07" Then
MsgBox ("yes")
Else
MsgBox ("No")
End If
End Sub

regards
reklamo


"Gemz" wrote:

Hi,

Please can you help on an IF statement.

I just need to know how i can say in an IF statement if cell E3 is <
03/03/07 then if true 'this' and not true 'that'. I have tried it like this
but although it works it gives me inaccurate results, i think its not
recognising the date properly.

All i want to say is if the dates in column E are less than 03/03/07 (i.e.
dates before this period then etc etc).

How can i state this in my IF statement?

thanks.