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.

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.

Hi

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

--
Regards
Roger Govier

"Gemz" wrote in message
...
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.

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
doesnt 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.

"reklamo" wrote:

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.

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

--
---
HTH

Bob


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



"Gemz" wrote in message
...
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.

Brilliant thank!!



"Roger Govier" wrote:

Hi

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

--
Regards
Roger Govier

"Gemz" wrote in message
...
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.