|
Formula For Date Comparisons
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 |
Formula For Date Comparisons
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 |
Formula For Date Comparisons
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 |
| All times are GMT +1. The time now is 12:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com