try
if(k2<j2,"e",if(k2j2,"L","O"))

--
Don Guillett
SalesAid Software

"Connie Martin" wrote in message
...
I need a formula that will likely be simple enough for all you gurus out
there, but beyond what I have mastered yet in Excel. Here it is:

Columns J and K are dates, so....In column L it should have this formula:
If K is an earlier date that J, results "EARLY"
If K is later than J, results "LATE"
If there is nothing in K, results "ON TIME"

Thank you in advance
Connie