Spreadsheet: 882807d1731285353-dynamic-solution-to-get-forecast-completion-date-based-on-conditions-production-target-excelforum-jt-
Sheet: Sheet1

 | Total | 200 |  |  | Target | Date
 | Completed | 100 |  |  | 100 | 2024-02-02 00:00:00
 | On Date | 2024-02-02 00:00:00 |  |  | 101 | 2024-02-02 00:00:00
 | Target Intervals | 1 |  |  | 102 | 2024-02-02 00:00:00
 |  |  |  |  | 103 | 2024-02-02 00:00:00
 | Production rates |  |  |  | 104 | 2024-02-02 00:00:00
 | Starting | Per Day |  |  | 105 | 2024-02-02 00:00:00
 | 1 | 50 |  |  | 106 | 2024-02-02 00:00:00
 | 151 | 10 |  |  | 107 | 2024-02-02 00:00:00
 | 181 | 5 |  |  | 108 | 2024-02-02 00:00:00
 |  |  |  |  | 109 | 2024-02-02 00:00:00
 | [NAME] |  |  |  | 110 | 2024-02-02 00:00:00
 | After target | Days |  |  | 111 | 2024-02-02 00:00:00
 | 50 | 2 |  |  | 112 | 2024-02-02 00:00:00
 | 150 | 5 |  |  | 113 | 2024-02-02 00:00:00
 | 180 | 3 |  |  | 114 | 2024-02-02 00:00:00
 |  |  |  |  | 115 | 2024-02-02 00:00:00
 | Completion Date | 2024-02-18 00:00:00 |  |  | 116 | 2024-02-02 00:00:00
 |  |  |  |  | 117 | 2024-02-02 00:00:00
 |  |  |  |  | 118 | 2024-02-02 00:00:00
 |  |  |  |  | 119 | 2024-02-02 00:00:00
 |  |  |  |  | 120 | 2024-02-02 00:00:00
 |  |  |  |  | 121 | 2024-02-02 00:00:00
 |  |  |  |  | 122 | 2024-02-02 00:00:00
 |  |  |  |  | 123 | 2024-02-02 00:00:00
 |  |  |  |  | 124 | 2024-02-02 00:00:00
 |  |  |  |  | 125 | 2024-02-02 00:00:00
 |  |  |  |  | 126 | 2024-02-02 00:00:00
 |  |  |  |  | 127 | 2024-02-02 00:00:00
 |  |  |  |  | 128 | 2024-02-02 00:00:00
 |  |  |  |  | 129 | 2024-02-02 00:00:00
 |  |  |  |  | 130 | 2024-02-02 00:00:00
 |  |  |  |  | 131 | 2024-02-02 00:00:00
 |  |  |  |  | 132 | 2024-02-02 00:00:00
 |  |  |  |  | 133 | 2024-02-02 00:00:00
 |  |  |  |  | 134 | 2024-02-02 00:00:00
 |  |  |  |  | 135 | 2024-02-02 00:00:00
 |  |  |  |  | 136 | 2024-02-02 00:00:00
 |  |  |  |  | 137 | 2024-02-02 00:00:00
 |  |  |  |  | 138 | 2024-02-02 00:00:00
 |  |  |  |  | 139 | 2024-02-02 00:00:00
 |  |  |  |  | 140 | 2024-02-02 00:00:00
 |  |  |  |  | 141 | 2024-02-02 00:00:00
 |  |  |  |  | 142 | 2024-02-02 00:00:00
 |  |  |  |  | 143 | 2024-02-02 00:00:00
 |  |  |  |  | 144 | 2024-02-02 00:00:00
 |  |  |  |  | 145 | 2024-02-02 00:00:00
 |  |  |  |  | 146 | 2024-02-02 00:00:00
 |  |  |  |  | 147 | 2024-02-02 00:00:00
 |  |  |  |  | 148 | 2024-02-02 00:00:00
 |  |  |  |  | 149 | 2024-02-02 00:00:00
 |  |  |  |  | 150 | 2024-02-03 00:00:00
 |  |  |  |  | 151 | 2024-02-08 00:00:00
 |  |  |  |  | 152 | 2024-02-08 00:00:00
 |  |  |  |  | 153 | 2024-02-08 00:00:00
 |  |  |  |  | 154 | 2024-02-08 00:00:00
 |  |  |  |  | 155 | 2024-02-08 00:00:00
 |  |  |  |  | 156 | 2024-02-08 00:00:00
 |  |  |  |  | 157 | 2024-02-08 00:00:00
 |  |  |  |  | 158 | 2024-02-08 00:00:00
 |  |  |  |  | 159 | 2024-02-08 00:00:00
 |  |  |  |  | 160 | 2024-02-09 00:00:00
 |  |  |  |  | 161 | 2024-02-09 00:00:00
 |  |  |  |  | 162 | 2024-02-09 00:00:00
 |  |  |  |  | 163 | 2024-02-09 00:00:00
 |  |  |  |  | 164 | 2024-02-09 00:00:00
 |  |  |  |  | 165 | 2024-02-09 00:00:00
 |  |  |  |  | 166 | 2024-02-09 00:00:00
 |  |  |  |  | 167 | 2024-02-09 00:00:00
 |  |  |  |  | 168 | 2024-02-09 00:00:00
 |  |  |  |  | 169 | 2024-02-09 00:00:00
 |  |  |  |  | 170 | 2024-02-10 00:00:00
 |  |  |  |  | 171 | 2024-02-10 00:00:00
 |  |  |  |  | 172 | 2024-02-10 00:00:00
 |  |  |  |  | 173 | 2024-02-10 00:00:00
 |  |  |  |  | 174 | 2024-02-10 00:00:00
 |  |  |  |  | 175 | 2024-02-10 00:00:00
 |  |  |  |  | 176 | 2024-02-10 00:00:00
 |  |  |  |  | 177 | 2024-02-10 00:00:00
 |  |  |  |  | 178 | 2024-02-10 00:00:00
 |  |  |  |  | 179 | 2024-02-10 00:00:00
 |  |  |  |  | 180 | 2024-02-11 00:00:00
 |  |  |  |  | 181 | 2024-02-14 00:00:00
 |  |  |  |  | 182 | 2024-02-14 00:00:00
 |  |  |  |  | 183 | 2024-02-14 00:00:00
 |  |  |  |  | 184 | 2024-02-14 00:00:00
 |  |  |  |  | 185 | 2024-02-15 00:00:00
 |  |  |  |  | 186 | 2024-02-15 00:00:00
 |  |  |  |  | 187 | 2024-02-15 00:00:00
 |  |  |  |  | 188 | 2024-02-15 00:00:00
 |  |  |  |  | 189 | 2024-02-15 00:00:00
 |  |  |  |  | 190 | 2024-02-16 00:00:00
 |  |  |  |  | 191 | 2024-02-16 00:00:00
 |  |  |  |  | 192 | 2024-02-16 00:00:00
 |  |  |  |  | 193 | 2024-02-16 00:00:00
 |  |  |  |  | 194 | 2024-02-16 00:00:00
 |  |  |  |  | 195 | 2024-02-17 00:00:00
 |  |  |  |  | 196 | 2024-02-17 00:00:00
 |  |  |  |  | 197 | 2024-02-17 00:00:00
 |  |  |  |  | 198 | 2024-02-17 00:00:00
 |  |  |  |  | 199 | 2024-02-17 00:00:00
 |  |  |  |  | 200 | 2024-02-18 00:00:00