Roy

If J2=TODAY() you get "Due Today"

If J2<TODAY() you get "Overdue"

K2=J2 or K2J2 can never be satisfied if either of the first two conditions
are true.

You are trying to satisfy too many conditions as far as I can see.

Conditons 1 or 2 come before conditions 3 or 4

You mention you put in the "appropriate date".

Where are you putting it?


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 11:46:00 -0800, Roy wrote:

yes calculation option is set to automatic.

"Eric" wrote:

Works for me just fine -- do you have your calculation option set to
automatic???

"Roy" wrote:

I need some help with this formula

=IF(A2=0,"",IF(J2=TODAY(),"Due
Today",IF(J2<TODAY(),"Overdue",(IF(K2<=J2,"Ontime" ,IF(K2J2,"Late"))))))

the value does not change to "ontime" or "late" when I put in the
appropriate date. What did I do wrong.