If formula error

  • Thread starter Thread starter Belinda7237
  • Start date Start date
B

Belinda7237

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")
 
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")
 
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)
 
thanks, that worked!

John C said:
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")
Click to expand...
 
Back
Top