Spreadsheet: 682221d1591967245-if-statement-with-search-and-match-dateexample
Sheet: Sheet1

Original Date | Status | Date1 | Date2 | Desired Results In Columns C & D |  |  | Original Date | Status | Date1 | Date2
2020-06-08 00:00:00 | RECONCILED | 2020-06-08 00:00:00 | 2020-06-08 00:00:00 | Correct |  |  | 2020-06-08 00:00:00 | RECONCILED | 2020-06-08 00:00:00 | 2020-06-08 00:00:00
2020-06-08 00:00:00 | RECONCILED | 2020-06-08 00:00:00 | 2020-06-08 00:00:00 | Correct |  |  | 2020-06-08 00:00:00 | RECONCILED | 2020-06-08 00:00:00 | 2020-06-08 00:00:00
2020-06-05 00:00:00 | RECONCILED | 2020-06-05 00:00:00 | 2020-06-05 00:00:00 | Correct |  |  | 2020-06-05 00:00:00 | RECONCILED | 2020-06-05 00:00:00 | 2020-06-05 00:00:00
2020-06-04 00:00:00 | False | False | False | Correct |  |  | 2020-06-04 00:00:00 | False | False | False
2020-06-02 00:00:00 | CHANGE | 2020-05-28 | 2020-05-29 | Correct |  |  | 2020-06-04 00:00:00 | CHANGE | 2020-05-28 | 2020-05-29
2020-06-05 00:00:00 | CHANGE | 2020-05-29 | 2020-06-01 | Correct |  |  | 2020-06-04 00:00:00 | CHANGE | 2020-05-29 | 2020-06-01
2020-06-06 00:00:00 | CHANGE | 2020-06-02 | 2020-06-03 | Correct |  |  | 2020-06-04 00:00:00 | CHANGE | 2020-06-02 | 2020-06-03
2020-06-04 00:00:00 | CHANGE | 2020-06-03 | 2020-06-04 | Correct |  |  | 2020-06-04 00:00:00 | CHANGE | 2020-06-03 | 2020-06-04
2020-06-04 00:00:00 | RECONCILED |  |  | C should be "2020-05-28" & D should be "2020-06-04" |  |  | 2020-06-04 00:00:00 | RECONCILED | 2020-05-28 | 2020-06-04
2020-06-04 00:00:00 | RECONCILED | 2020-06-04 00:00:00 | 2020-06-04 00:00:00 | Correct |  |  | 2020-06-04 00:00:00 | RECONCILED | 2020-06-04 00:00:00 | 2020-06-04 00:00:00
2020-06-04 00:00:00 | RECONCILED | 2020-06-04 00:00:00 | 2020-06-04 00:00:00 | Correct |  |  | 2020-06-04 00:00:00 | RECONCILED | 2020-06-04 00:00:00 | 2020-06-04 00:00:00
2020-06-04 00:00:00 | RECONCILED | 2020-06-04 00:00:00 | 2020-06-04 00:00:00 | Correct |  |  | 2020-06-04 00:00:00 | RECONCILED | 2020-06-04 00:00:00 | 2020-06-04 00:00:00
2020-06-04 00:00:00 | False | False | False | Correct |  |  | 2020-06-04 00:00:00 | False | False | False
2020-06-04 00:00:00 | RECONCILED | 2020-06-04 00:00:00 | 2020-06-04 00:00:00 | Correct |  |  | 2020-06-04 00:00:00 | RECONCILED | 2020-06-04 00:00:00 | 2020-06-04 00:00:00
2020-06-04 00:00:00 | RECONCILED | 2020-06-04 00:00:00 | 2020-06-04 00:00:00 | Correct |  |  | 2020-06-04 00:00:00 | RECONCILED | 2020-06-04 00:00:00 | 2020-06-04 00:00:00
2020-06-04 00:00:00 | RECONCILED | 2020-06-04 00:00:00 | 2020-06-04 00:00:00 | Correct |  |  | 2020-06-04 00:00:00 | RECONCILED | 2020-06-04 00:00:00 | 2020-06-04 00:00:00
2020-06-04 00:00:00 | RECONCILED | 2020-06-04 00:00:00 | 2020-06-04 00:00:00 | Correct |  |  | 2020-06-04 00:00:00 | RECONCILED | 2020-06-04 00:00:00 | 2020-06-04 00:00:00
2020-06-05 00:00:00 | False | False | False | Correct |  |  | 2020-06-05 00:00:00 | False | False | False
2020-06-05 00:00:00 | CHANGE | 2020-06-04 | 2020-06-05 | Correct |  |  | 2020-06-05 00:00:00 | CHANGE | 2020-06-04 | 2020-06-05
2020-06-05 00:00:00 | RECONCILED | 2020-06-05 00:00:00 | 2020-06-05 00:00:00 | C should be "2020-06-04" & D should be "2020-06-05" |  |  | 2020-06-05 00:00:00 | RECONCILED | 2020-06-04 | 2020-06-05