CAN YOU HELP WITH A FORMULA?

[Guest]

I am trying to ascertain from a list of dates which items need to be done.
Have used the "If" function and embedded the "TODAY" formula within that. I
have tried this several ways, but cannot get it to work properly. The
formula I have at the moment is
=IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2>"TODAY","DO"))), but whether or
not the date is before, after or on today, I get the same answer of "DO."
Can you tell me where I'm going wrong?

 

[Guest]

Change your formula to:
=IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO",IF(J2>TODAY(),"DO")))
last if you can ignore:
=IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO","DO"))

pls do rate

 

[Guest]

Nearly there but not quite... OKs are showing fine, but the "DOs" are coming
out with the #NAME? error. Any ideas?

Thanks & regards,

 

[Guest]

Ooooooooops Sorry. i forgot to put =

Change your formula to:
=IF(J2<TODAY(),"OK",IF(J2=TODAY(),"DO",IF(J2>TODAY(),"DO")))
last if you can ignore:
=IF(J2<TODAY(),"OK",IF(J2=TODAY(),"DO","DO"))

 

[Guest]

Try this ...
=IF(J2<TODAY(),"OK",IF(J2=TODAY(),"DO",IF(J2>TODAY(),"DO")))

Please rate me.

 

[Guest]

Sorry if this comes up twice... I thought I had posted a message, but it
does not appear to be showing. Thanks for your help - I am half way there,
but am still getting an error message. The "OKs" are coming out alright, but
the "DOs" are coming up with a #NAME? error. Any ideas how to resolsve this?

Thanks & regards,

 

[Rob]

or more simply....
=IF(J2<TODAY(),"OK",IF(J2>=TODAY(),"DO"))

Rob

 

[Guest]

Brilliant! Sorted! Thanks for your help.....