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