software

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 quot;EARLYquot;
If K is later than J, results quot;LATEquot;
If there is nothing in K, results quot;ON TIMEquot;

Thank you in advance
Connie

try
if(k2lt;j2,quot;equot;,if(k2gt;j2,quot;Lquot;,quot;Oquot;))

--
Don Guillett
SalesAid Software

quot;Connie Martinquot; gt; wrote in message
...
gt;I need a formula that will likely be simple enough for all you gurus out
gt; there, but beyond what I have mastered yet in Excel. Here it is:
gt;
gt; Columns J and K are dates, so....In column L it should have this formula:
gt; If K is an earlier date that J, results quot;EARLYquot;
gt; If K is later than J, results quot;LATEquot;
gt; If there is nothing in K, results quot;ON TIMEquot;
gt;
gt; Thank you in advance
gt; Connie
Your statement, and Don's answer, both ignore K=J.

If quot;On Timequot; is the answer ONLY when K is blank, then

=if(k2=quot;quot;,quot;On Timequot;,if(K2gt;j2,quot;Latequot;,quot;Earlyquot;))

In this formula, when K=J you'll get quot;Earlyquot; as a result.

=if(or(k2=j2,k2=quot;quot;),quot;On Timequot;,if(K2gt;j2,quot;Latequot;,quot;Earlyquot;))

In this case you'll get quot;On Timequot; when K=J
quot;Connie Martinquot; wrote:

gt; I need a formula that will likely be simple enough for all you gurus out
gt; there, but beyond what I have mastered yet in Excel. Here it is:
gt;
gt; Columns J and K are dates, so....In column L it should have this formula:
gt; If K is an earlier date that J, results quot;EARLYquot;
gt; If K is later than J, results quot;LATEquot;
gt; If there is nothing in K, results quot;ON TIMEquot;
gt;
gt; Thank you in advance
gt; 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

quot;Don Guillettquot; wrote:

gt; try
gt; if(k2lt;j2,quot;equot;,if(k2gt;j2,quot;Lquot;,quot;Oquot;))
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Connie Martinquot; gt; wrote in message
gt; ...
gt; gt;I need a formula that will likely be simple enough for all you gurus out
gt; gt; there, but beyond what I have mastered yet in Excel. Here it is:
gt; gt;
gt; gt; Columns J and K are dates, so....In column L it should have this formula:
gt; gt; If K is an earlier date that J, results quot;EARLYquot;
gt; gt; If K is later than J, results quot;LATEquot;
gt; gt; If there is nothing in K, results quot;ON TIMEquot;
gt; gt;
gt; gt; Thank you in advance
gt; gt; Connie
gt;
gt;
gt;

happy now? lt;Ggt; Assumes that K will be entered last and accounts for the
quot;dreaded space barquot;
=IF(LEN(K2)lt;2,quot;quot;,IF(K2lt;J2,quot;equot;,IF(K2gt;J2,quot;Lquot;,quot;Oquot;)))

--
Don Guillett
SalesAid Software

quot;Duke Careyquot; gt; wrote in message
...
gt; Your statement, and Don's answer, both ignore K=J.
gt;
gt; If quot;On Timequot; is the answer ONLY when K is blank, then
gt;
gt; =if(k2=quot;quot;,quot;On Timequot;,if(K2gt;j2,quot;Latequot;,quot;Earlyquot;))
gt;
gt; In this formula, when K=J you'll get quot;Earlyquot; as a result.
gt;
gt; =if(or(k2=j2,k2=quot;quot;),quot;On Timequot;,if(K2gt;j2,quot;Latequot;,quot;Earlyquot;))
gt;
gt; In this case you'll get quot;On Timequot; when K=J
gt;
gt;
gt;
gt; quot;Connie Martinquot; wrote:
gt;
gt;gt; I need a formula that will likely be simple enough for all you gurus out
gt;gt; there, but beyond what I have mastered yet in Excel. Here it is:
gt;gt;
gt;gt; Columns J and K are dates, so....In column L it should have this formula:
gt;gt; If K is an earlier date that J, results quot;EARLYquot;
gt;gt; If K is later than J, results quot;LATEquot;
gt;gt; If there is nothing in K, results quot;ON TIMEquot;
gt;gt;
gt;gt; Thank you in advance
gt;gt; Connie
Sorry to say, but none of this works.

quot;Don Guillettquot; wrote:

gt; happy now? lt;Ggt; Assumes that K will be entered last and accounts for the
gt; quot;dreaded space barquot;
gt; =IF(LEN(K2)lt;2,quot;quot;,IF(K2lt;J2,quot;equot;,IF(K2gt;J2,quot;Lquot;,quot;Oquot;)))
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Duke Careyquot; gt; wrote in message
gt; ...
gt; gt; Your statement, and Don's answer, both ignore K=J.
gt; gt;
gt; gt; If quot;On Timequot; is the answer ONLY when K is blank, then
gt; gt;
gt; gt; =if(k2=quot;quot;,quot;On Timequot;,if(K2gt;j2,quot;Latequot;,quot;Earlyquot;))
gt; gt;
gt; gt; In this formula, when K=J you'll get quot;Earlyquot; as a result.
gt; gt;
gt; gt; =if(or(k2=j2,k2=quot;quot;),quot;On Timequot;,if(K2gt;j2,quot;Latequot;,quot;Earlyquot;))
gt; gt;
gt; gt; In this case you'll get quot;On Timequot; when K=J
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Connie Martinquot; wrote:
gt; gt;
gt; gt;gt; I need a formula that will likely be simple enough for all you gurus out
gt; gt;gt; there, but beyond what I have mastered yet in Excel. Here it is:
gt; gt;gt;
gt; gt;gt; Columns J and K are dates, so....In column L it should have this formula:
gt; gt;gt; If K is an earlier date that J, results quot;EARLYquot;
gt; gt;gt; If K is later than J, results quot;LATEquot;
gt; gt;gt; If there is nothing in K, results quot;ON TIMEquot;
gt; gt;gt;
gt; gt;gt; Thank you in advance
gt; gt;gt; Connie
gt;
gt;
gt;

Golly it's hard to diagnose quot;none of this worksquot; Do you think you can spare
a few facts?

quot;Connie Martinquot; wrote:

gt; Sorry to say, but none of this works.
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt; gt; happy now? lt;Ggt; Assumes that K will be entered last and accounts for the
gt; gt; quot;dreaded space barquot;
gt; gt; =IF(LEN(K2)lt;2,quot;quot;,IF(K2lt;J2,quot;equot;,IF(K2gt;J2,quot;Lquot;,quot;Oquot;)))
gt; gt;
gt; gt; --
gt; gt; Don Guillett
gt; gt; SalesAid Software
gt; gt;
gt; gt; quot;Duke Careyquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Your statement, and Don's answer, both ignore K=J.
gt; gt; gt;
gt; gt; gt; If quot;On Timequot; is the answer ONLY when K is blank, then
gt; gt; gt;
gt; gt; gt; =if(k2=quot;quot;,quot;On Timequot;,if(K2gt;j2,quot;Latequot;,quot;Earlyquot;))
gt; gt; gt;
gt; gt; gt; In this formula, when K=J you'll get quot;Earlyquot; as a result.
gt; gt; gt;
gt; gt; gt; =if(or(k2=j2,k2=quot;quot;),quot;On Timequot;,if(K2gt;j2,quot;Latequot;,quot;Earlyquot;))
gt; gt; gt;
gt; gt; gt; In this case you'll get quot;On Timequot; when K=J
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Connie Martinquot; wrote:
gt; gt; gt;
gt; gt; gt;gt; I need a formula that will likely be simple enough for all you gurus out
gt; gt; gt;gt; there, but beyond what I have mastered yet in Excel. Here it is:
gt; gt; gt;gt;
gt; gt; gt;gt; Columns J and K are dates, so....In column L it should have this formula:
gt; gt; gt;gt; If K is an earlier date that J, results quot;EARLYquot;
gt; gt; gt;gt; If K is later than J, results quot;LATEquot;
gt; gt; gt;gt; If there is nothing in K, results quot;ON TIMEquot;
gt; gt; gt;gt;
gt; gt; gt;gt; Thank you in advance
gt; gt; gt;gt; Connie
gt; gt;
gt; gt;
gt; gt;

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

--
Don Guillett
SalesAid Software

quot;Connie Martinquot; gt; wrote in message
...
gt; Sorry to say, but none of this works.
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt;gt; happy now? lt;Ggt; Assumes that K will be entered last and accounts for the
gt;gt; quot;dreaded space barquot;
gt;gt; =IF(LEN(K2)lt;2,quot;quot;,IF(K2lt;J2,quot;equot;,IF(K2gt;J2,quot;Lquot;,quot;Oquot;)))
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;Duke Careyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Your statement, and Don's answer, both ignore K=J.
gt;gt; gt;
gt;gt; gt; If quot;On Timequot; is the answer ONLY when K is blank, then
gt;gt; gt;
gt;gt; gt; =if(k2=quot;quot;,quot;On Timequot;,if(K2gt;j2,quot;Latequot;,quot;Earlyquot;))
gt;gt; gt;
gt;gt; gt; In this formula, when K=J you'll get quot;Earlyquot; as a result.
gt;gt; gt;
gt;gt; gt; =if(or(k2=j2,k2=quot;quot;),quot;On Timequot;,if(K2gt;j2,quot;Latequot;,quot;Earlyquot;))
gt;gt; gt;
gt;gt; gt; In this case you'll get quot;On Timequot; when K=J
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Connie Martinquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; I need a formula that will likely be simple enough for all you gurus
gt;gt; gt;gt; out
gt;gt; gt;gt; there, but beyond what I have mastered yet in Excel. Here it is:
gt;gt; gt;gt;
gt;gt; gt;gt; Columns J and K are dates, so....In column L it should have this
gt;gt; gt;gt; formula:
gt;gt; gt;gt; If K is an earlier date that J, results quot;EARLYquot;
gt;gt; gt;gt; If K is later than J, results quot;LATEquot;
gt;gt; gt;gt; If there is nothing in K, results quot;ON TIMEquot;
gt;gt; gt;gt;
gt;gt; gt;gt; Thank you in advance
gt;gt; gt;gt; Connie
gt;gt;
gt;gt;
gt;gt;
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-06Feb-02-06Early
Feb-06-06On Time
Feb-01-06On Time
Feb-17-06Jan-31-06Early
Feb-01-06Feb-06-06Late

Connie

quot;Don Guillettquot; wrote:

gt; Perhaps your dates are not really dates???? maybe show us. Mind reading is
gt; extra.
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Connie Martinquot; gt; wrote in message
gt; ...
gt; gt; Sorry to say, but none of this works.
gt; gt;
gt; gt; quot;Don Guillettquot; wrote:
gt; gt;
gt; gt;gt; happy now? lt;Ggt; Assumes that K will be entered last and accounts for the
gt; gt;gt; quot;dreaded space barquot;
gt; gt;gt; =IF(LEN(K2)lt;2,quot;quot;,IF(K2lt;J2,quot;equot;,IF(K2gt;J2,quot;Lquot;,quot;Oquot;)))
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Don Guillett
gt; gt;gt; SalesAid Software
gt; gt;gt;
gt; gt;gt; quot;Duke Careyquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Your statement, and Don's answer, both ignore K=J.
gt; gt;gt; gt;
gt; gt;gt; gt; If quot;On Timequot; is the answer ONLY when K is blank, then
gt; gt;gt; gt;
gt; gt;gt; gt; =if(k2=quot;quot;,quot;On Timequot;,if(K2gt;j2,quot;Latequot;,quot;Earlyquot;))
gt; gt;gt; gt;
gt; gt;gt; gt; In this formula, when K=J you'll get quot;Earlyquot; as a result.
gt; gt;gt; gt;
gt; gt;gt; gt; =if(or(k2=j2,k2=quot;quot;),quot;On Timequot;,if(K2gt;j2,quot;Latequot;,quot;Earlyquot;))
gt; gt;gt; gt;
gt; gt;gt; gt; In this case you'll get quot;On Timequot; when K=J
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Connie Martinquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; I need a formula that will likely be simple enough for all you gurus
gt; gt;gt; gt;gt; out
gt; gt;gt; gt;gt; there, but beyond what I have mastered yet in Excel. Here it is:
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Columns J and K are dates, so....In column L it should have this
gt; gt;gt; gt;gt; formula:
gt; gt;gt; gt;gt; If K is an earlier date that J, results quot;EARLYquot;
gt; gt;gt; gt;gt; If K is later than J, results quot;LATEquot;
gt; gt;gt; gt;gt; If there is nothing in K, results quot;ON TIMEquot;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Thank you in advance
gt; gt;gt; gt;gt; Connie
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Tested.

=IF(AND(F7gt;1,G7lt;1),quot;oquot;,IF(G7lt;F7,quot;equot;,IF(G7gt;F7,quot;lquot;,quot; quot;)))

--
Don Guillett
SalesAid Software

quot;Connie Martinquot; gt; wrote in message
...
gt; Okay, you guys are real funny! Sorry for the delay in getting back
gt; here.
gt; It's just been so busy. Anyway, my dates are in date format. Here is a
gt; sample. The third column is what the formula SHOULD yield.
gt;
gt; Feb-08-06 Feb-02-06 Early
gt; Feb-06-06 On Time
gt; Feb-01-06 On Time
gt; Feb-17-06 Jan-31-06 Early
gt; Feb-01-06 Feb-06-06 Late
gt;
gt; Connie
gt;
gt;
gt;
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt;gt; Perhaps your dates are not really dates???? maybe show us. Mind reading
gt;gt; is
gt;gt; extra.
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;Connie Martinquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Sorry to say, but none of this works.
gt;gt; gt;
gt;gt; gt; quot;Don Guillettquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; happy now? lt;Ggt; Assumes that K will be entered last and accounts for
gt;gt; gt;gt; the
gt;gt; gt;gt; quot;dreaded space barquot;
gt;gt; gt;gt; =IF(LEN(K2)lt;2,quot;quot;,IF(K2lt;J2,quot;equot;,IF(K2gt;J2,quot;Lquot;,quot;Oquot;)))
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt; Don Guillett
gt;gt; gt;gt; SalesAid Software
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Duke Careyquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Your statement, and Don's answer, both ignore K=J.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; If quot;On Timequot; is the answer ONLY when K is blank, then
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; =if(k2=quot;quot;,quot;On Timequot;,if(K2gt;j2,quot;Latequot;,quot;Earlyquot;))
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; In this formula, when K=J you'll get quot;Earlyquot; as a result.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; =if(or(k2=j2,k2=quot;quot;),quot;On Timequot;,if(K2gt;j2,quot;Latequot;,quot;Earlyquot;))
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; In this case you'll get quot;On Timequot; when K=J
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; quot;Connie Martinquot; wrote:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; I need a formula that will likely be simple enough for all you
gt;gt; gt;gt; gt;gt; gurus
gt;gt; gt;gt; gt;gt; out
gt;gt; gt;gt; gt;gt; there, but beyond what I have mastered yet in Excel. Here it is:
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Columns J and K are dates, so....In column L it should have this
gt;gt; gt;gt; gt;gt; formula:
gt;gt; gt;gt; gt;gt; If K is an earlier date that J, results quot;EARLYquot;
gt;gt; gt;gt; gt;gt; If K is later than J, results quot;LATEquot;
gt;gt; gt;gt; gt;gt; If there is nothing in K, results quot;ON TIMEquot;
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Thank you in advance
gt;gt; gt;gt; gt;gt; Connie
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;