simple IF statement

[Gemz]

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.

 

[reklamo]

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

 

[Roger Govier]

Hi

=IF(E3<--"03/03/07","this","that")
or
=IF(E3<DATE(2007,3,3),"this","that")

 

[Gemz]

Hi, this has worked but its not what I want. Basically if the person has a
date before this date then the column will say a certain thing, this is how
the user will monitor the students progress. Simply having a message box
doesn’t show me who has a date older than the date specified and it means it
would have to be clicked many times to get through the list of names to see
who is yes and who is no . can i not have this as an IF statement that i can
write in the spreadsheet?

Mine looks like this at the mo, it works but not correctly.

=IF(E4<30/3/2007,"POOR PROGRESS","GOOD PROGRESS")

thanks.

 

[Bob Phillips]

=IF(E3<DATE(2007,3,3),...

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gemz]

Brilliant thank!!

Hi

=IF(E3<--"03/03/07","this","that")
or
=IF(E3<DATE(2007,3,3),"this","that")