Tested.

=IF(AND(F71,G7<1),"o",IF(G7<F7,"e",IF(G7F7,"l"," ")))

--
Don Guillett
SalesAid Software

"Connie Martin" wrote in message
...
Okay, you guys are real funny! :) Sorry for the delay in getting back
here.
It's just been so busy. Anyway, my dates are in date format. Here is a
sample. The third column is what the formula SHOULD yield.

Feb-08-06 Feb-02-06 Early
Feb-06-06 On Time
Feb-01-06 On Time
Feb-17-06 Jan-31-06 Early
Feb-01-06 Feb-06-06 Late

Connie




"Don Guillett" wrote:

Perhaps your dates are not really dates???? maybe show us. Mind reading
is
extra.

--
Don Guillett
SalesAid Software

"Connie Martin" wrote in message
...
Sorry to say, but none of this works.

"Don Guillett" wrote:

happy now? <G Assumes that K will be entered last and accounts for
the
"dreaded space bar"
=IF(LEN(K2)<2,"",IF(K2<J2,"e",IF(K2J2,"L","O")))

--
Don Guillett
SalesAid Software

"Duke Carey" wrote in message
...
Your statement, and Don's answer, both ignore K=J.

If "On Time" is the answer ONLY when K is blank, then

=if(k2="","On Time",if(K2j2,"Late","Early"))

In this formula, when K=J you'll get "Early" as a result.

=if(or(k2=j2,k2=""),"On Time",if(K2j2,"Late","Early"))

In this case you'll get "On Time" when K=J



"Connie Martin" wrote:

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