Spreadsheet: 753777d1635757357-countifs-with-date-example-help
Sheet: 17. full raw data

[NAME] | Date Sent | Date Voted | Date Commented | Vote | Comment | Status | Additional Vote 1 | Additional Vote 2 | Additional Vote 3 | Additional Vote 4 | Additional Vote 5 | Attribute 1 | Attribute 2 | Attribute 3 | Attribute 4 | Attribute 5 | Requested For First Name | Requested For Last Name | Requested For Email | Requested For Phone Number | Country | Region | Service Request ID | ticket number | Vendor Ticket Number | Summary | Template Name | Operational Categorization Tier 1 | Operational Categorization Tier 2 | Operational Categorization Tier 3 | Resolution Date | Resolved by | Department | Organization | Site | Site Group | Resolving Company | Resolving Organization | Resolving Group | Resolving Assignee | Resolution
REQ000003124553 | 2020-01-01 06:04:37 | 2020-01-02 09:36:38 | 2020-01-02 09:36:44.303000 | 3 | xxxx | Closed |  |  |  |  |  |  |  |  |  |  | aaaa | bbb | [EMAIL] | 0 | India | Asia-Pacific | REQ000003124553 | INC000003111388 |  | APAC/1  Bangalore/Citrix VDI | Citrix VDI | Repair | Software | Application | 2019-12-31 08:34:50 | xxxx | Engineering | Civil | India | Bangalore - Manyata Block L3 | HP-Compute | Compute | HP-Compute-Global-ITSM | HP SD2SD User01 | 31/12/2019 08:34:16 ([NAME]): Call solved completely
REQ000003025315 | 2020-01-01 06:04:44.557000 | 2020-01-06 09:46:09.577000 | 2020-01-06 09:50:17.237000 | 2 | xxxx | Closed |  |  |  |  |  |  |  |  |  |  | aaaa | bbb | [EMAIL] | 0 | India | Asia-Pacific | REQ000003025315 | WO0000010558034 |  | APAC/1  Bangalore/Citrix VDI | Citrix VDI | Add/Procure | Software | Application | 2019-12-31 10:01:47 | xxxx | Engineering | Civil | India | Bangalore - Manyata Block L3 | HP-Compute | Compute | HP-Compute-Global-ITSM | HP SD2SD User01 | 31/12/2019 08:34:16 ([NAME]): Call solved completely
REQ000003125374 | 2020-01-01 06:04:49.167000 | 2020-01-02 08:13:41.813000 | 2020-01-02 08:14:16.250000 | 5 | xxxx | Closed |  |  |  |  |  |  |  |  |  |  | aaaa | bbb | [EMAIL] | 0 | India | Asia-Pacific | REQ000003125374 | INC000003112589 |  | APAC/1  Bangalore/Citrix VDI | Citrix VDI | Repair | Software | Application | 2019-12-31 12:42:59 | xxxx | Engineering | Civil | India | Bangalore - Manyata Block L3 | HP-Compute | Compute | HP-Compute-Global-ITSM | HP SD2SD User01 | 31/12/2019 08:34:16 ([NAME]): Call solved completely
REQ000003124122 | 2020-01-02 06:04:27.880000 | 2020-01-06 17:32:40.720000 | 2020-01-06 17:33:36.127000 | 4 | xxxx | Closed |  |  |  |  |  |  |  |  |  |  | aaaa | bbb | [EMAIL] | 0 | India | Asia-Pacific | REQ000003124122 | INC000003111072 |  | APAC/1  Bangalore/Citrix VDI | Citrix VDI | Repair | Software | Application | 2020-01-01 01:03:50 | xxxx | Engineering | Civil | India | Bangalore - Manyata Block L3 | HP-Compute | Compute | HP-Compute-Global-ITSM | HP SD2SD User01 | 31/12/2019 08:34:16 ([NAME]): Call solved completely
REQ000003098969 | 2020-01-03 06:04:40.157000 | 2020-01-03 07:47:37.417000 | 2020-01-03 07:49:15.183000 | 2 | xxxx | Closed |  |  |  |  |  |  |  |  |  |  | aaaa | bbb | [EMAIL] | 0 | India | Asia-Pacific | REQ000003098969 | INC000003095302 |  | APAC/1  Bangalore/Citrix VDI | Citrix VDI | Repair | Software | Application | 2020-01-02 13:15:16 | xxxx | Engineering | Civil | India | Bangalore - Manyata Block L3 | HP-Compute | Compute | HP-Compute-Global-ITSM | HP SD2SD User01 | 31/12/2019 08:34:16 ([NAME]): Call solved completely
REQ000003122848 | 2020-01-03 06:04:40.657000 | 2020-01-03 08:23:44.750000 |  | 1 | xxxx | PendingComment |  |  |  |  |  |  |  |  |  |  | aaaa | bbb | [EMAIL] | 0 | India | Asia-Pacific | REQ000003122848 | WO0000012104543 |  | APAC/1  Bangalore/Citrix VDI | Citrix VDI | Add | Software | Application | 2020-01-02 10:09:39 | xxxx | Engineering | Civil | India | Bangalore - Manyata Block L3 | HP-Compute | Compute | HP-Compute-Global-ITSM | HP SD2SD User01 | 31/12/2019 08:34:16 ([NAME]): Call solved completely
REQ000003120587 | 2020-01-03 06:04:45.483000 | 2020-01-03 06:54:25.910000 | 2020-01-03 06:54:31.257000 | 4 | xxxx | Closed |  |  |  |  |  |  |  |  |  |  | aaaa | bbb | [EMAIL] | 0 | India | Asia-Pacific | REQ000003120587 | INC000003109123 |  | APAC/1  Bangalore/Citrix VDI | Citrix VDI | Repair | Software | Application | 2020-01-02 08:12:13 | xxxx | Engineering | Civil | India | Bangalore - Manyata Block L3 | HP-Compute | Compute | HP-Compute-Global-ITSM | HP SD2SD User01 | 31/12/2019 08:34:16 ([NAME]): Call solved completely