Always best to use a non-ambguous date format, in case it gets sent abroad

=IF(U2=--"2008-07-02","I","E")

--
HTH

Bob

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

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