Besides A2 being not equal to 0, do you realize that if J2 is not greater
(later) then today, you'll never see "Ontime" or "Late" returned by the
formula, no matter what's in K2?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Roy" wrote in message
...
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.