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


"Naveen" wrote:

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

Please rate me.

"Mary Mace" wrote:

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"TODA Y","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?
--
MARY