Re: Formula For Date Comparisons
- From: JW <JWRIGHT50@xxxxxxxxxxxx>
- Date: Tue, 09 Oct 2007 09:50:33 -0700
Appolgies. Typo in previous formula:
=IF(ISBLANK(L1),IF(AND(H1>I1,K1<I1),"Extract",IF(OR(AND(H1>I1,K1>I1),AND(H1<I1,K1<I1)),"Not
Extract")),"col L not blank")
JW wrote:
One way:
=IF(ISBLANK(L1),IF(AND(H1>I1,K1<I1),"Extract",IF(OR(AND(H1>I1,K1>I1),AND(H1<I1,K1<I1)),"Not
Extract","col L not blank")))
foofoo wrote:
Can anyone help me with a formula involving dates? I'm so
confused . . .
I need to write the formula in cell A1. The formula needs to compare
the following columns:
Column H - Today's Date
Column I - Close Date
Column K - Create Date
Column L - Ticket Close Date
The formula in cell A1 needs to account for the following conditions:
If Column H is greater than Column I, and if Column K is less than
Column I, and if Column L is blank, formula result should display
"Extract." OR if Column H is greater than I and if Column K is
greater than Column I; and if Column L is blank, formula should
display "Not Extract". OR if Column H is less than Column I,and if
Column K is less than Column I, and if Column L is blank, formula
result should display "Not Extract".
Examples of what I am looking for are shown below:
EXAMPLE 1
A1 H1 I1 K1 L1
Extract 10/09/07 09/21/07 09/13/07
EXAMPLE 2
A1 H1 I1 K1 L1
Not Extract 10/09/07 09/14/07 10/08/07
EXAMPLE 3
A1 H1 I1 K1 L1
Not Extract 10/09/07 01/18/08 10/08/07
I am not comfortable working woth programs and would prefer to tackle
this problem with a formula.
Thanks!
Sandi
.
- References:
- Formula For Date Comparisons
- From: foofoo
- Re: Formula For Date Comparisons
- From: JW
- Formula For Date Comparisons
- Prev by Date: Re: Searching for case specific data
- Next by Date: Re: How do I match and append/merge data from two spreadsheets?
- Previous by thread: Re: Formula For Date Comparisons
- Next by thread: Re: Searching for case specific data
- Index(es):
Relevant Pages
|
