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

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

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

Thank you for replying. I'm heading home now for the day. Will look at this
in the a.m. Please check back then. Connie

"Don Guillett" wrote:

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

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

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

Golly it's hard to diagnose "none of this works" Do you think you can spare
a few facts?

"Connie Martin" wrote:

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

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

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

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

BINGO! Thank you! That works! Too bad when we copy and paste columns in
these messages that they wouldn't stay the way we paste them. I see what I
pasted is all bunched together, which it wasn't when I sent it. But you were
able to decipher it anyway, thank goodness! Thanks again. Connie

"Don Guillett" wrote:

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

glad you finally got it like you wanted it

--
Don Guillett
SalesAid Software

"Connie Martin" wrote in message
...
BINGO! Thank you! That works! Too bad when we copy and paste columns in
these messages that they wouldn't stay the way we paste them. I see what
I
pasted is all bunched together, which it wasn't when I sent it. But you
were
able to decipher it anyway, thank goodness! Thanks again. Connie

"Don Guillett" wrote:

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