Spreadsheet: 868717d1715362028-please-help-need-a-date-formula-samplexl
Sheet: Testing Formulas

QYLS WF Rating | QYLS Protocol | QYLS First Detected | QYLS Last Detected | Days Open | Past Threshold | QYLS WF Emergency | PAA_IND | Server Competency Comments | Everything Else Comments | Resubmit using DateValue | Output Expected
High |  | 2023-10-25 23:37:43 | 2024-04-11 01:33:41 | 169 |  | False | True | 2024-12-08 00:00:00 | adadadadad 1/2/2024 |  | Should say resend
High |  | 2023-11-15 20:43:06 | 2024-04-16 22:19:15 | 153 |  | False | True |  | 5/8/2024 -skdfhskfjhsf |  | Should say resend
High |  | 2023-11-15 22:20:50 | 2024-04-16 23:30:49 | 153 |  | False | True | Raised exception until Nov 2023 | 2/1/2024 -hello my name is Maz |  | Should say resend
High |  | 2023-11-15 23:44:13 | 2024-04-17 23:03:17 | 154 |  | False | True | Raised exception until Nov 2023 | 2024-01-01 00:00:00
High |  | 2023-11-15 20:37:58 | 2024-04-16 22:41:07 | 153 |  | False | True | Raised exception until Nov 2023
High |  | 2023-11-16 23:42:30 | 2024-04-11 21:57:11 | 147 |  | False | True | Raised exception until Nov 2023 | 2024-04-04 00:00:00
High |  | 2023-11-16 20:16:37 | 2024-04-12 19:33:16 | 148 |  | False | True
High |  | 2023-11-16 22:13:08 | 2024-04-11 22:18:46 | 147 |  | False | True | Raised exception until Nov 2023 | 2024-05-10 00:00:00
High |  | 2023-11-21 23:01:54 | 2024-04-09 21:06:11 | 140 |  | False | True | Raised exception until Nov 2023 | 2023-01-01 00:00:00
High |  | 2023-11-21 22:12:23 | 2024-04-17 01:57:16 | 148 |  | False | True | Raised exception until Nov 2023
High |  | 2024-02-14 23:00:02 | 2024-04-17 23:03:17 | 63 |  | False | True |  | sdsdsdsdsd |  | Should say resend
High |  | 2024-02-15 00:45:54 | 2024-04-16 22:12:53 | 61 |  | False | True
High |  | 2024-02-14 23:43:13 | 2024-04-17 01:39:17 | 63 |  | False | True |  | dlsfjlasdkfjasldkfjasdfl |  | Should say resend
High |  | 2024-02-15 22:08:17 | 2024-04-11 21:57:11 | 56 |  | False | True
High |  | 2024-02-15 21:26:05 | 2024-04-11 22:18:46 | 56 |  | False | True |  | 2024-05-09 00:00:00
High |  | 2024-02-20 20:51:30 | 2024-04-16 22:19:15 | 56 |  | False | True |  | sfsdfdsf
High |  | 2024-02-20 21:38:43 | 2024-04-09 21:53:11 | 49 |  | False | True |  | 2024-04-02 00:00:00
High |  | 2024-02-20 21:01:42 | 2024-04-09 21:06:11 | 29 |  | False | True |  | sfsfsfsff
High |  | 2024-02-20 20:57:19 | 2024-04-09 20:46:37 | 49 |  | False | True |  | 6/1/2024-PATCH
High |  | 2024-02-20 20:50:40 | 2024-04-16 22:41:07 | 56 |  | False | True |  | 3/1/2024: DRD |  | Should say resend
High |  | 2024-02-20 20:04:57 | 2024-04-09 20:53:48 | 49 |  | False | True
High |  | 2024-02-20 20:07:33 | 2024-04-17 01:57:16 | 57 |  | False | True
High |  | 2024-02-20 21:19:28 | 2024-04-12 19:33:16 | 52 |  | False | True
High |  | 2024-02-20 21:17:27 | 2024-04-16 23:30:49 | 15 |  | False | True
High |  | 2024-04-16 19:23:33 | 2024-04-16 19:23:33 | 14 |  | False | True
High |  | 2024-04-16 18:34:12 | 2024-04-16 18:34:12 | 0 |  | False | True
High |  | 2024-04-17 19:21:14 | 2024-04-17 19:21:14 | 5 |  | False | True
High |  | 2024-04-17 19:03:24 | 2024-04-17 19:03:24 | 2 |  | False | True
High |  | 2024-04-17 23:57:41 | 2024-04-17 23:57:41 | 0 |  | False | True
High |  | 2024-04-17 20:20:27 | 2024-04-17 20:20:27 | 0 |  | False | False
High |  | 2024-02-20 20:50:40 | 2024-04-16 22:41:07 | 56 |  | False | False
High |  | 2024-02-20 20:04:57 | 2024-04-09 20:53:48 | 15 |  | False | False
High |  | 2024-02-20 20:07:33 | 2024-04-17 01:57:16 | 29 |  | False
High |  | 2024-02-20 21:19:28 | 2024-04-12 19:33:16 | 52 |  | False | False
High |  | 2024-02-20 21:17:27 | 2024-04-16 23:30:49 | 56 |  | False
High |  | 2024-04-16 19:23:33 | 2024-04-16 19:23:33 | 31 |  | False | False
High |  | 2024-04-16 18:34:12 | 2024-04-16 18:34:12 | 30 |  | False
High |  | 2024-04-17 19:21:14 | 2024-04-17 19:21:14 | 0 |  | False
High |  | 2024-04-17 19:03:24 | 2024-04-17 19:03:24 | 30 |  | False | False