Spreadsheet: 38189d1236288618-formula-to-increment-indirect-references-book1
Sheet: Sheet2

 |  | Lookup Table
 | 1 | January | '0091 911'!$E$2
 | 2 | February | '0091 911'!$E$33
 | 3 | March | '0091 911'!$E$62
 | 4 | April | '0091 911'!$E$93
 | 5 | May | '0091 911'!$E$123
 | 6 | June | '0091 911'!$E$154
 | 7 | July | '0091 911'!$E$184
 | 8 | August | '0091 911'!$E$215
 | 9 | September | '0091 911'!$E$246
 | 10 | October | '0091 911'!$E$276
 | 11 | November | '0091 911'!$E$307
 | 12 | December | '0091 911'!$E$337
 |  |  |  | 9
 |  |  |  |  | Month | September
 |  |  |  |  |  | 1900-01-01 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
 |  |  |  | September | 1st | 34 | 37 | 36 | 36 | 36 | 35 | 46 | 101 | 130 | 158 | 159 | 167 | 173 | 178 | 184 | 182 | 180 | 184 | 184 | 180 | 177 | 180 | 175 | 178 | 176 | 178 | 175 | 171 | 172
 |  |  |  | September | 2nd | 37 | 38 | 36 | 37 | 36 | 37 | 48 | 115 | 129 | 157 | 152 | 160 | 166 | 172 | 177 | 177 | 179 | 176 | 178 | 177 | 176 | 172 | 169 | 172 | 174 | 173 | 175 | 172 | 173
 |  |  |  | September | 3rd | 40 | 42 | 42 | 40 | 42 | 42 | 51 | 111 | 117 | 144 | 150 | 156 | 161 | 171 | 173 | 174 | 174 | 175 | 176 | 171 | 171 | 169 | 165 | 167 | 169 | 170 | 167 | 167 | 163
 |  |  |  | September | 4th | 40 | 40 | 40 | 40 | 40 | 40 | 54 | 112 | 118 | 150 | 147 | 153 | 160 | 164 | 170 | 175 | 178 | 176 | 177 | 172 | 175 | 173 | 169 | 167 | 171 | 167 | 172 | 166 | 167
 |  |  |  | September | 5th | 42 | 41 | 43 | 42 | 43 | 41 | 54 | 112 | 118 | 143 | 148 | 148 | 154 | 163 | 171 | 170 | 169 | 169 | 167 | 165 | 165 | 165 | 161 | 162 | 165 | 162 | 161 | 164 | 160
 |  |  |  | September | 6th | 42 | 42 | 42 | 42 | 41 | 42 | 41 | 43 | 41 | 41 | 45 | 48 | 46 | 48 | 47 | 49 | 49 | 49 | 62 | 62 | 60 | 67 | 72 | 73 | 73 | 77 | 77 | 76 | 58
 |  |  |  | September | 7th | 37 | 37 | 37 | 38 | 37 | 37 | 38 | 37 | 36 | 39 | 36 | 43 | 42 | 41 | 43 | 43 | 43 | 44 | 58 | 58 | 53 | 53 | 51 | 51 | 51 | 49 | 50 | 47 | 47
 |  |  |  | September | 8th | 36 | 38 | 37 | 37 | 37 | 36 | 51 | 111 | 113 | 144 | 141 | 149 | 154 | 166 | 167 | 170 | 171 | 169 | 171 | 169 | 170 | 170 | 164 | 167 | 167 | 167 | 165 | 164 | 163
 |  |  |  | September | 9th | 38 | 38 | 37 | 37 | 37 | 39 | 52 | 111 | 115 | 145 | 151 | 151 | 157 | 168 | 170 | 173 | 171 | 176 | 173 | 173 | 174 | 174 | 173 | 174 | 172 | 168 | 169 | 168 | 162
 |  |  |  | September | 10th | 41 | 41 | 41 | 41 | 40 | 44 | 52 | 110 | 113 | 144 | 142 | 147 | 160 | 169 | 177 | 177 | 178 | 174 | 175 | 171 | 175 | 173 | 171 | 174 | 172 | 169 | 172 | 172 | 168
 |  |  |  | September | 11th | 41 | 41 | 41 | 41 | 40 | 44 | 71 | 116 | 121 | 152 | 157 | 155 | 164 | 174 | 182 | 181 | 175 | 174 | 172 | 168 | 167 | 168 | 163 | 171 | 165 | 167 | 169 | 167 | 163
 |  |  |  | September | 12th | 42 | 43 | 42 | 44 | 42 | 44 | 73 | 116 | 120 | 152 | 145 | 150 | 160 | 165 | 167 | 167 | 166 | 168 | 168 | 167 | 169 | 167 | 162 | 164 | 168 | 165 | 165 | 162 | 163
 |  |  |  | September | 13th | 39 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 39 | 41 | 40 | 39 | 38 | 40 | 50 | 69 | 72 | 72 | 88 | 87 | 86 | 87 | 87 | 88 | 85 | 88 | 85 | 85 | 68
 |  |  |  | September | 14th | 38 | 39 | 38 | 37 | 38 | 38 | 37 | 38 | 38 | 38 | 39 | 39 | 40 | 40 | 40 | 41 | 43 | 43 | 54 | 54 | 52 | 49 | 48 | 49 | 49 | 48 | 48 | 46 | 48
 |  |  |  | September | 15th | 36 | 39 | 37 | 37 | 36 | 39 | 53 | 109 | 114 | 134 | 141 | 149 | 154 | 161 | 162 | 164 | 168 | 168 | 166 | 167 | 169 | 173 | 173 | 170 | 171 | 169 | 165 | 164 | 165
 |  |  |  | September | 16th | 39 | 37 | 37 | 36 | 37 | 38 | 49 | 105 | 111 | 135 | 143 | 148 | 155 | 163 | 163 | 164 | 166 | 169 | 169 | 165 | 167 | 168 | 165 | 164 | 167 | 165 | 165 | 163 | 160
 |  |  |  | September | 17th | 42 | 41 | 41 | 43 | 41 | 44 | 58 | 109 | 114 | 143 | 141 | 146 | 152 | 164 | 167 | 166 | 166 | 169 | 170 | 174 | 174 | 167 | 168 | 165 | 168 | 166 | 163 | 163 | 161
 |  |  |  | September | 18th | 40 | 39 | 40 | 39 | 39 | 40 | 64 | 105 | 105 | 140 | 141 | 145 | 154 | 165 | 171 | 174 | 172 | 172 | 172 | 169 | 171 | 166 | 166 | 164 | 169 | 170 | 169 | 169 | 162
 |  |  |  | September | 19th | 37 | 38 | 37 | 38 | 36 | 40 | 59 | 109 | 111 | 138 | 137 | 142 | 148 | 159 | 166 | 165 | 166 | 164 | 163 | 163 | 162 | 162 | 159 | 160 | 163 | 165 | 165 | 161 | 156
 |  |  |  | September | 20th | 37 | 37 | 37 | 37 | 37 | 38 | 37 | 37 | 36 | 38 | 37 | 38 | 37 | 38 | 38 | 40 | 41 | 43 | 55 | 56 | 52 | 50 | 50 | 49 | 48 | 49 | 50 | 49 | 49
 |  |  |  | September | 21st | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 36 | 37 | 37 | 37 | 37 | 38 | 38 | 38 | 38 | 39 | 51 | 51 | 49 | 48 | 49 | 47 | 49 | 48 | 47 | 48 | 46
 |  |  |  | September | 22nd | 35 | 37 | 35 | 36 | 36 | 37 | 68 | 108 | 110 | 135 | 140 | 147 | 149 | 156 | 164 | 166 | 167 | 167 | 162 | 164 | 165 | 166 | 166 | 166 | 165 | 165 | 163 | 160 | 158
 |  |  |  | September | 23rd | 39 | 39 | 37 | 39 | 39 | 41 | 61 | 105 | 108 | 137 | 140 | 144 | 150 | 153 | 161 | 164 | 165 | 168 | 167 | 167 | 169 | 172 | 169 | 166 | 167 | 167 | 166 | 161 | 158
 |  |  |  | September | 24th | 38 | 36 | 39 | 36 | 39 | 65 | 75 | 108 | 112 | 135 | 146 | 148 | 158 | 162 | 168 | 167 | 169 | 173 | 174 | 171 | 174 | 172 | 171 | 169 | 171 | 172 | 169 | 168 | 165
 |  |  |  | September | 25th | 40 | 41 | 41 | 39 | 41 | 57 | 76 | 114 | 115 | 152 | 149 | 152 | 158 | 167 | 168 | 168 | 173 | 172 | 169 | 170 | 170 | 173 | 169 | 171 | 171 | 175 | 174 | 169 | 172
 |  |  |  | September | 26th | 38 | 39 | 39 | 39 | 40 | 42 | 53 | 110 | 117 | 145 | 145 | 147 | 152 | 165 | 169 | 169 | 174 | 168 | 171 | 168 | 164 | 162 | 163 | 160 | 167 | 164 | 166 | 162 | 164
 |  |  |  | September | 27th | 38 | 36 | 38 | 38 | 36 | 38 | 37 | 38 | 38 | 36 | 38 | 41 | 49 | 50 | 53 | 51 | 53 | 52 | 66 | 65 | 64 | 64 | 67 | 68 | 68 | 65 | 63 | 61 | 49
 |  |  |  | September | 28th | 37 | 36 | 37 | 36 | 37 | 37 | 35 | 37 | 36 | 37 | 37 | 38 | 37 | 38 | 37 | 38 | 37 | 38 | 51 | 51 | 48 | 49 | 47 | 47 | 49 | 46 | 48 | 47 | 48
 |  |  |  | September | 29th | 36 | 35 | 37 | 36 | 37 | 40 | 50 | 108 | 112 | 137 | 142 | 148 | 153 | 160 | 162 | 170 | 168 | 169 | 169 | 166 | 172 | 170 | 165 | 164 | 165 | 165 | 166 | 164 | 162
 |  |  |  | September | 30th | 38 | 35 | 37 | 36 | 37 | 53 | 76 | 110 | 112 | 140 | 142 | 149 | 158 | 159 | 163 | 169 | 166 | 164 | 165 | 164 | 158 | 163 | 157 | 159 | 160 | 162 | 158 | 156 | 152
 |  |  |  | September | 31st |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A