Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Yr to Yr comparisons | Excel Discussion (Misc queries) | |||
Multiply IF AND OR comparisons | Excel Worksheet Functions | |||
Spreadsheet Comparisons | Excel Discussion (Misc queries) | |||
Can I add more than 2 comparisons to an IF statement?? | Excel Discussion (Misc queries) | |||
string comparisons | Excel Discussion (Misc queries) |