If formula error
 

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")

If formula error
 

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")

If formula error
 

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")

If formula error
 

thanks, that worked!

"John C" wrote:

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")