Spreadsheet: 728748d1618596602-excel-formula-items-open-within-a-month-items-open-example
Sheet: Sheet1

Item | Status | Date Item Open | Date Resolved |  | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00
Item 7 | Closed | 2018-01-01 00:00:00 | 2018-07-01 00:00:00
Item 9 | Closed | 2018-01-01 00:00:00 | 2018-12-12 00:00:00
Item 10 | Closed | 2018-01-01 00:00:00 | 2018-12-12 00:00:00
Item 82 | Closed | 2018-01-01 00:00:00 | 2018-06-01 00:00:00
Item 83 | Closed | 2018-01-01 00:00:00 | 2018-06-01 00:00:00
Item 65 | Closed | 2018-01-04 00:00:00 | 2018-03-01 00:00:00
Item 66 | Closed | 2018-01-04 00:00:00 | 2018-01-17 00:00:00
Item 33 | Closed | 2018-01-09 00:00:00 | 2019-02-13 00:00:00
Item 47 | Closed | 2018-01-11 00:00:00 | 2019-06-01 00:00:00
Item 48 | Closed | 2018-01-11 00:00:00 | 2018-01-25 00:00:00
Item 49 | Closed | 2018-01-11 00:00:00 | 2018-01-12 00:00:00
Item 50 | Closed | 2018-01-12 00:00:00 | 2018-02-01 00:00:00
Item 51 | Closed | 2018-01-12 00:00:00 | 2018-02-01 00:00:00
Item 52 | Closed | 2018-01-17 00:00:00 | 2018-04-01 00:00:00
Item 67 | Closed | 2018-01-18 00:00:00 | 2018-05-03 00:00:00
Item 53 | Closed | 2018-01-22 00:00:00 | 2018-01-31 00:00:00
Item 54 | Closed | 2018-02-12 00:00:00 | 2018-04-23 00:00:00
Item 55 | Closed | 2018-02-12 00:00:00 | 2018-04-04 00:00:00
Item 56 | Closed | 2018-02-13 00:00:00 | 2018-04-05 00:00:00
Item 57 | Closed | 2018-02-15 00:00:00 | 2018-04-01 00:00:00
Item 58 | Closed | 2018-02-22 00:00:00 | 2018-06-21 00:00:00
Item 87 | Closed | 2018-02-27 00:00:00 | 2018-03-01 00:00:00
Item 59 | Closed | 2018-03-06 00:00:00 | 2018-03-21 00:00:00
Item 60 | Closed | 2018-03-07 00:00:00 | 2018-10-08 00:00:00
Item 61 | Closed | 2018-03-13 00:00:00 | 2018-06-04 00:00:00
Item 62 | Closed | 2018-03-21 00:00:00 | 2018-04-12 00:00:00
Item 63 | Closed | 2018-03-27 00:00:00 | 2018-04-25 00:00:00
Item 64 | Closed | 2018-04-05 00:00:00 | 2018-05-30 00:00:00
Item 75 | Closed | 2018-04-13 00:00:00 | 2018-07-27 00:00:00
Item 68 | Closed | 2018-05-03 00:00:00 | 2018-05-14 00:00:00
Item 86 | Closed | 2018-05-03 00:00:00 | 2018-07-31 00:00:00
Item 69 | Closed | 2018-05-08 00:00:00 | 2019-01-08 00:00:00
Item 42 | Closed | 2018-05-09 00:00:00 | 2018-07-20 00:00:00
Item 73 | Closed | 2018-05-10 00:00:00 | 2018-09-03 00:00:00
Item 70 | Closed | 2018-05-11 00:00:00 | 2018-05-25 00:00:00
Item 71 | Closed | 2018-05-15 00:00:00 | 2018-05-25 00:00:00
Item 74 | Closed | 2018-05-17 00:00:00 | 2018-05-30 00:00:00
Item 77 | Closed | 2018-05-21 00:00:00 | 2018-06-22 00:00:00
Item 76 | Closed | 2018-05-24 00:00:00 | 2018-08-22 00:00:00
Item 5 | Closed | 2018-05-25 00:00:00 | 2018-06-09 00:00:00
Item 78 | Closed | 2018-06-06 00:00:00 | 2018-06-11 00:00:00
Item 79 | Closed | 2018-06-06 00:00:00 | 2018-06-11 00:00:00
Item 80 | Closed | 2018-06-11 00:00:00 | 2018-07-12 00:00:00
Item 81 | Closed | 2018-06-12 00:00:00 | 2018-08-29 00:00:00
Item 45 | Closed | 2018-06-19 00:00:00 | 2018-08-08 00:00:00
Item 85 | Closed | 2018-06-26 00:00:00 | 2018-08-01 00:00:00
Item 84 | Closed | 2018-06-28 00:00:00 | 2018-09-07 00:00:00
Item 44 | Closed | 2018-07-05 00:00:00 | 2018-08-13 00:00:00
Item 43 | Closed | 2018-07-10 00:00:00 | 2018-08-29 00:00:00
Item 4 | Closed | 2018-07-12 00:00:00 | 2018-12-12 00:00:00
Item 46 | Closed | 2018-07-19 00:00:00 | 2018-08-29 00:00:00
Item 3 | Closed | 2018-07-27 00:00:00 | 2018-09-05 00:00:00
Item 18 | Closed | 2018-08-15 00:00:00 | 2018-12-11 00:00:00
Item 6 | Closed | 2018-09-03 00:00:00 | 2018-10-01 00:00:00
Item 29 | Closed | 2018-09-04 00:00:00 | 2018-10-30 00:00:00
Item 2 | Closed | 2018-09-27 00:00:00 | 2019-03-04 00:00:00
Item 11 | Closed | 2018-10-02 00:00:00 | 2019-02-11 00:00:00
Item 19 | Closed | 2018-10-02 00:00:00 | 2018-11-03 00:00:00
Item 72 | Closed | 2018-10-04 00:00:00 | 2018-10-22 00:00:00
Item 41 | Closed | 2018-10-22 00:00:00 | 2018-11-12 00:00:00
Item 38 | Closed | 2018-10-23 00:00:00 | 2018-11-02 00:00:00
Item 12 | Closed | 2018-10-24 00:00:00 | 2018-11-09 00:00:00
Item 14 | Closed | 2018-10-24 00:00:00 | 2019-02-18 00:00:00
Item 23 | Closed | 2018-10-25 00:00:00 | 2019-03-21 00:00:00
Item 13 | Closed | 2018-10-26 00:00:00 | 2018-11-06 00:00:00
Item 16 | Closed | 2018-11-02 00:00:00 | 2018-11-16 00:00:00
Item 36 | Closed | 2018-11-08 00:00:00 | 2018-12-30 00:00:00
Item 15 | Closed | 2018-11-15 00:00:00 | 2019-04-05 00:00:00
Item 39 | Closed | 2018-11-15 00:00:00 | 2019-04-05 00:00:00
Item 37 | Closed | 2018-11-19 00:00:00 | 2019-02-05 00:00:00
Item 17 | Closed | 2018-11-30 00:00:00 | 2019-05-07 00:00:00
Item 20 | Closed | 2018-12-05 00:00:00 | 2019-04-30 00:00:00
Item 1 | Closed | 2018-12-10 00:00:00 | 2018-12-27 00:00:00
Item 21 | Closed | 2018-12-10 00:00:00 | 2018-12-20 00:00:00
Item 8 | Closed | 2018-12-14 00:00:00 | 2019-12-27 00:00:00
Item 24 | Closed | 2018-12-19 00:00:00 | 2019-01-03 00:00:00
Item 28 | Closed | 2019-01-02 00:00:00 | 2019-02-26 00:00:00
Item 26 | Closed | 2019-01-03 00:00:00 | 2019-02-07 00:00:00
Item 27 | Closed | 2019-01-03 00:00:00 | 2019-02-01 00:00:00
Item 40 | Closed | 2019-01-05 00:00:00 | 2019-05-07 00:00:00
Item 22 | Closed | 2019-01-07 00:00:00 | 2019-07-16 00:00:00
Item 30 | Closed | 2019-01-07 00:00:00 | 2019-05-30 00:00:00
Item 25 | Closed | 2019-01-09 00:00:00 | 2019-03-21 00:00:00
Item 32 | Closed | 2019-01-09 00:00:00 | 2019-02-13 00:00:00
Item 35 | Closed | 2019-01-09 00:00:00 | 2019-01-25 00:00:00
Item 95 | Closed | 2019-01-09 00:00:00 | 2019-02-25 00:00:00
Item 34 | Closed | 2019-01-11 00:00:00 | 2019-02-13 00:00:00
Item 103 | Closed | 2019-01-17 00:00:00 | 2019-04-19 00:00:00
Item 104 | Closed | 2019-01-17 00:00:00 | 2019-04-19 00:00:00
Item 105 | Closed | 2019-01-17 00:00:00 | 2019-04-19 00:00:00
Item 106 | Closed | 2019-01-17 00:00:00 | 2019-05-29 00:00:00
Item 107 | Closed | 2019-01-17 00:00:00 | 2019-04-01 00:00:00
Item 93 | Closed | 2019-01-21 00:00:00 | 2019-10-25 00:00:00
Item 92 | Closed | 2019-01-29 00:00:00 | 2019-03-18 00:00:00
Item 31 | Closed | 2019-02-01 00:00:00 | 2019-06-01 00:00:00
Item 88 | Closed | 2019-02-04 00:00:00 | 2019-03-29 00:00:00
Item 89 | Closed | 2019-02-04 00:00:00 | 2019-03-29 00:00:00
Item 90 | Closed | 2019-02-04 00:00:00 | 2019-03-01 00:00:00
Item 91 | Closed | 2019-02-04 00:00:00 | 2019-03-01 00:00:00
Item 112 | Closed | 2019-02-06 00:00:00 | 2019-06-12 00:00:00
Item 113 | Closed | 2019-02-12 00:00:00 | 2019-07-05 00:00:00
Item 94 | Closed | 2019-02-19 00:00:00 | 2019-02-25 00:00:00
Item 96 | Closed | 2019-02-22 00:00:00 | 2019-05-13 00:00:00
Item 97 | Closed | 2019-02-22 00:00:00 | 2019-05-13 00:00:00
Item 98 | Closed | 2019-02-22 00:00:00 | 2019-04-05 00:00:00
Item 99 | Closed | 2019-02-22 00:00:00 | 2019-04-05 00:00:00
Item 100 | Closed | 2019-02-22 00:00:00 | 2019-04-05 00:00:00
Item 101 | Closed | 2019-02-22 00:00:00 | 2019-04-05 00:00:00
Item 102 | Closed | 2019-02-22 00:00:00 | 2019-04-05 00:00:00
Item 108 | Closed | 2019-02-28 00:00:00 | 2019-05-13 00:00:00
Item 109 | Closed | 2019-02-28 00:00:00 | 2019-05-13 00:00:00
Item 110 | Closed | 2019-03-11 00:00:00 | 2019-06-12 00:00:00
Item 111 | Closed | 2019-03-11 00:00:00 | 2019-06-12 00:00:00
Item 116 | Closed | 2019-03-25 00:00:00 | 2019-04-30 00:00:00
Item 114 | Closed | 2019-03-28 00:00:00 | 2019-05-02 00:00:00
Item 119 | Closed | 2019-04-02 00:00:00 | 2019-11-04 00:00:00
Item 115 | Closed | 2019-04-04 00:00:00 | 2019-05-24 00:00:00
Item 117 | Closed | 2019-04-09 00:00:00 | 2019-05-29 00:00:00
Item 118 | Closed | 2019-04-16 00:00:00 | 2019-07-08 00:00:00
Item 120 | Closed | 2019-04-16 00:00:00 | 2019-06-12 00:00:00
Item 121 | Closed | 2019-04-16 00:00:00 | 2019-06-28 00:00:00
Item 122 | Closed | 2019-04-16 00:00:00 | 2019-06-28 00:00:00
Item 123 | Closed | 2019-05-14 00:00:00 | 2019-07-09 00:00:00
Item 124 | Closed | 2019-05-14 00:00:00 | 2019-08-12 00:00:00
Item 132 | Closed | 2019-06-28 00:00:00 | 2019-11-18 00:00:00
Item 125 | Closed | 2019-07-02 00:00:00 | 2019-08-27 00:00:00
Item 126 | Closed | 2019-07-02 00:00:00 | 2019-08-27 00:00:00
Item 169 | Closed | 2019-07-04 00:00:00 | 2020-11-28 00:00:00
Item 128 | Closed | 2019-07-17 00:00:00 | 2020-02-07 00:00:00
Item 129 | Closed | 2019-07-18 00:00:00 | 2020-08-06 00:00:00
Item 130 | Closed | 2019-08-06 00:00:00 | 2020-10-02 00:00:00
Item 131 | Closed | 2019-08-07 00:00:00 | 2019-09-10 00:00:00
Item 136 | Closed | 2019-08-22 00:00:00 | 2020-01-10 00:00:00
Item 135 | Closed | 2019-08-28 00:00:00 | 2019-09-04 00:00:00
Item 133 | Closed | 2019-08-30 00:00:00 | 2019-10-14 00:00:00
Item 134 | Closed | 2019-08-30 00:00:00 | 2019-11-05 00:00:00
Item 138 | Closed | 2019-09-05 00:00:00 | 2019-11-01 00:00:00
Item 139 | Closed | 2019-09-09 00:00:00 | 2019-11-01 00:00:00
Item 137 | Closed | 2019-09-16 00:00:00 | 2019-10-28 00:00:00
Item 143 | Closed | 2019-09-20 00:00:00 | 2019-11-04 00:00:00
Item 140 | Closed | 2019-09-27 00:00:00 | 2019-12-16 00:00:00
Item 142 | Closed | 2019-10-01 00:00:00 | 2019-11-10 00:00:00
Item 144 | Closed | 2019-10-09 00:00:00 | 2019-11-22 00:00:00
Item 141 | Closed | 2019-10-11 00:00:00 | 2019-11-05 00:00:00
Item 186 | Closed | 2019-10-25 00:00:00 | 2019-12-04 00:00:00
Item 146 | Closed | 2019-11-19 00:00:00 | 2020-01-09 00:00:00
Item 147 | Closed | 2019-11-19 00:00:00 | 2020-01-09 00:00:00
Item 156 | Closed | 2019-11-19 00:00:00 | 2020-01-27 00:00:00
Item 154 | Closed | 2019-11-20 00:00:00 | 2019-12-17 00:00:00
Item 155 | Closed | 2019-11-20 00:00:00 | 2020-02-01 00:00:00
Item 148 | Closed | 2019-11-22 00:00:00 | 2020-06-09 00:00:00
Item 158 | Closed | 2019-11-22 00:00:00 | 2020-02-27 00:00:00
Item 151 | Closed | 2019-11-26 00:00:00 | 2020-01-21 00:00:00
Item 149 | Closed | 2019-11-29 00:00:00 | 2020-06-01 00:00:00
Item 150 | Closed | 2019-12-03 00:00:00 | 2020-01-01 00:00:00
Item 153 | Closed | 2019-12-09 00:00:00 | 2020-06-17 00:00:00
Item 163 | Closed | 2019-12-09 00:00:00 | 2020-06-17 00:00:00
Item 164 | Closed | 2019-12-09 00:00:00 | 2020-06-17 00:00:00
Item 170 | Closed | 2019-12-09 00:00:00 | 2020-06-17 00:00:00
Item 222 | Closed | 2019-12-09 00:00:00 | 2021-02-24 00:00:00
Item 152 | Closed | 2019-12-17 00:00:00 | 2020-01-16 00:00:00
Item 157 | Closed | 2019-12-17 00:00:00 | 2020-05-28 00:00:00
Item 145 | Closed | 2019-12-27 00:00:00 | 2020-02-27 00:00:00
Item 162 | Closed | 2020-01-03 00:00:00 | 2020-01-17 00:00:00
Item 161 | Closed | 2020-01-06 00:00:00 | 2020-04-22 00:00:00
Item 159 | Closed | 2020-01-08 00:00:00 | 2020-07-20 00:00:00
Item 165 | Closed | 2020-01-16 00:00:00 | 2021-04-14 00:00:00
Item 176 | Closed | 2020-01-22 00:00:00 | 2020-03-12 00:00:00
Item 167 | Closed | 2020-01-27 00:00:00 | 2020-05-22 00:00:00
Item 127 | Closed | 2020-02-03 00:00:00 | 2020-03-03 00:00:00
Item 168 | Closed | 2020-02-11 00:00:00 | 2020-04-01 00:00:00
Item 166 | Closed | 2020-02-19 00:00:00 | 2020-04-09 00:00:00
Item 160 | Closed | 2020-02-20 00:00:00 | 2020-04-09 00:00:00
Item 171 | Closed | 2020-03-02 00:00:00 | 2020-11-03 00:00:00
Item 177 | Closed | 2020-03-02 00:00:00 | 2020-05-19 00:00:00
Item 175 | Closed | 2020-03-04 00:00:00 | 2020-03-26 00:00:00
Item 180 | Closed | 2020-03-06 00:00:00 | 2020-04-03 00:00:00
Item 173 | Closed | 2020-03-09 00:00:00 | 2020-04-20 00:00:00
Item 187 | Closed | 2020-03-09 00:00:00 | 2020-06-17 00:00:00
Item 179 | Closed | 2020-03-13 00:00:00 | 2020-04-03 00:00:00
Item 185 | Closed | 2020-03-17 00:00:00 | 2020-05-19 00:00:00
Item 172 | Closed | 2020-03-19 00:00:00 | 2020-06-19 00:00:00
Item 178 | Closed | 2020-03-20 00:00:00 | 2020-04-03 00:00:00
Item 174 | Closed | 2020-03-24 00:00:00 | 2020-04-09 00:00:00
Item 181 | Closed | 2020-03-24 00:00:00 | 2020-09-10 00:00:00
Item 182 | Closed | 2020-03-24 00:00:00 | 2020-09-10 00:00:00
Item 189 | Closed | 2020-03-30 00:00:00 | 2020-05-19 00:00:00
Item 183 | Closed | 2020-04-01 00:00:00 | 2020-06-09 00:00:00
Item 184 | Closed | 2020-04-07 00:00:00 | 2020-06-10 00:00:00
Item 188 | Closed | 2020-04-07 00:00:00 | 2020-04-07 00:00:00
Item 190 | Closed | 2020-04-08 00:00:00 | 2020-08-19 00:00:00
Item 196 | Closed | 2020-04-09 00:00:00 | 2020-06-08 00:00:00
Item 191 | Closed | 2020-04-13 00:00:00 | 2020-05-01 00:00:00
Item 192 | Closed | 2020-04-13 00:00:00 | 2020-04-17 00:00:00
Item 194 | Closed | 2020-04-15 00:00:00 | 2020-07-02 00:00:00
Item 193 | Closed | 2020-04-16 00:00:00 | 2020-05-05 00:00:00
Item 199 | Closed | 2020-04-20 00:00:00 | 2020-06-09 00:00:00
Item 197 | Closed | 2020-04-23 00:00:00 | 2020-07-21 00:00:00
Item 195 | Closed | 2020-04-27 00:00:00 | 2020-06-01 00:00:00
Item 198 | Closed | 2020-04-30 00:00:00 | 2020-05-28 00:00:00
Item 200 | Closed | 2020-05-07 00:00:00 | 2020-06-24 00:00:00
Item 203 | Closed | 2020-05-13 00:00:00 | 2020-06-11 00:00:00
Item 201 | Closed | 2020-05-26 00:00:00 | 2020-07-24 00:00:00
Item 202 | Closed | 2020-06-10 00:00:00 | 2020-07-07 00:00:00
Item 204 | Closed | 2020-06-29 00:00:00 | 2020-06-29 00:00:00
Item 205 | Closed | 2020-06-29 00:00:00 | 2020-06-29 00:00:00
Item 206 | Closed | 2020-07-07 00:00:00 | 2020-11-02 00:00:00
Item 210 | Closed | 2020-07-07 00:00:00 | 2020-10-14 00:00:00
Item 208 | Closed | 2020-07-08 00:00:00 | 2020-08-19 00:00:00
Item 207 | Closed | 2020-07-10 00:00:00 | 2020-08-06 00:00:00
Item 214 | Closed | 2020-07-15 00:00:00 | 2020-10-23 00:00:00
Item 209 | Closed | 2020-07-16 00:00:00 | 2020-07-20 00:00:00
Item 211 | Closed | 2020-08-07 00:00:00 | 2020-08-14 00:00:00
Item 212 | Closed | 2020-08-13 00:00:00 | 2020-09-09 00:00:00
Item 217 | Closed | 2020-08-30 00:00:00 | 2020-11-09 00:00:00
Item 213 | Closed | 2020-09-10 00:00:00 | 2020-11-03 00:00:00
Item 220 | Closed | 2020-10-08 00:00:00 | 2021-02-05 00:00:00
Item 215 | Closed | 2020-10-09 00:00:00 | 2020-11-12 00:00:00
Item 216 | Closed | 2020-10-09 00:00:00 | 2020-11-27 00:00:00
Item 219 | Closed | 2020-10-14 00:00:00 | 2020-11-03 00:00:00
Item 218 | Closed | 2020-10-19 00:00:00 | 2021-02-02 00:00:00
Item 221 | Closed | 2020-11-12 00:00:00 | 2020-12-02 00:00:00
Item 226 | Closed | 2020-11-20 00:00:00 | 2021-01-22 00:00:00
Item 225 | Closed | 2020-11-25 00:00:00 | 2021-01-19 00:00:00
Item 223 | Closed | 2020-11-26 00:00:00 | 2021-02-12 00:00:00
Item 224 | Open | 2020-12-03 00:00:00
Item 229 | Open | 2020-12-04 00:00:00
Item 236 | Closed | 2020-12-08 00:00:00 | 2021-02-15 00:00:00
Item 227 | Closed | 2020-12-15 00:00:00 | 2021-02-09 00:00:00
Item 228 | Open | 2020-12-29 00:00:00
Item 233 | Closed | 2021-01-15 00:00:00 | 2021-02-24 00:00:00
Item 230 | Closed | 2021-01-19 00:00:00 | 2021-02-17 00:00:00
Item 231 | Open | 2021-01-19 00:00:00
Item 232 | Open | 2021-01-22 00:00:00
Item 234 | Open | 2021-01-22 00:00:00
Item 237 | Closed | 2021-01-29 00:00:00 | 2021-02-18 00:00:00
Item 235 | Closed | 2021-02-05 00:00:00 | 2021-03-22 00:00:00
Item 243 | Open | 2021-03-11 00:00:00
Item 239 | Open | 2021-03-12 00:00:00
Item 238 | Open | 2021-03-31 00:00:00
Item 240 | Open | 2021-04-08 00:00:00
Item 241 | Open | 2021-04-09 00:00:00
Item 242 | Open | 2021-04-15 00:00:00