You need to ensure the date in quotes is treated as a number, easy way is
with --.

So your entry would be:
=IF(U2=--"7/02/2008","I","E")

--
John C


"Belinda7237" wrote:

I have a date field in column U and I wanted to return an I in this column if
the date in U2 is higher (in the future) then 7/2/2008 - I wrote the below
formula but its returning an E in every case which it should not. Have I
written this wrong?

=IF(U2="7/02/2008","I","E")