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

One way:
=IF(ISBLANK(L1),IF(AND(H1I1,K1<I1),"Extract",IF(O R(AND(H1I1,K1I1),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

Appolgies. Typo in previous formula:
=IF(ISBLANK(L1),IF(AND(H1I1,K1<I1),"Extract",IF(O R(AND(H1I1,K1I1),AND(H1<I1,K1<I1)),"Not
Extract")),"col L not blank")
JW wrote:
One way:
=IF(ISBLANK(L1),IF(AND(H1I1,K1<I1),"Extract",IF(O R(AND(H1I1,K1I1),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