Spreadsheet: 151079d1334773609-excel-2007-using-vlookup-to-find-a-range-of-dates-sample-exp-date
Sheet: Sheet1

Site Number | Current Expiration | Renew Date | Vacate Date
215 | 2011-04-30 00:00:00 | 2011-01-30 00:00:00 | 2011-01-30 00:00:00
330 | 2012-03-08 00:00:00 | 2011-12-09 00:00:00 | 2011-12-09 00:00:00
340 | 2012-03-08 00:00:00 | 2011-12-09 00:00:00 | 2011-12-09 00:00:00
329 | 2012-03-08 00:00:00 | 2011-12-09 00:00:00 | 2011-12-09 00:00:00
370 | 2012-03-08 00:00:00 | 2011-12-09 00:00:00 | 2011-12-09 00:00:00
363 | 2012-03-08 00:00:00 | 2011-12-09 00:00:00 | 2011-12-09 00:00:00
146 | 2012-04-17 00:00:00 | 2012-01-18 00:00:00 | 2012-01-18 00:00:00
33 | 2012-04-30 00:00:00 | 2012-01-31 00:00:00 | 2012-01-31 00:00:00
32 | 2012-04-30 00:00:00 | 2012-01-31 00:00:00 | 2012-01-31 00:00:00
187 | 2012-06-09 00:00:00 | 2012-03-11 00:00:00 | 2011-12-12 00:00:00
261 | 2012-06-12 00:00:00 | 2012-03-14 00:00:00 | 2012-05-13 00:00:00
77 | 2012-06-29 00:00:00 | 2012-03-31 00:00:00 | 2012-03-31 00:00:00
159 | 2012-05-31 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00
259 | 2012-06-30 00:00:00 | 2012-04-01 00:00:00 | 2012-04-01 00:00:00
161 | 2012-08-06 00:00:00 | 2012-05-08 00:00:00 | 2012-05-08 00:00:00
167 | 2012-08-06 00:00:00 | 2012-05-08 00:00:00 | 2012-05-08 00:00:00
367 | 2012-06-15 00:00:00 | 2012-05-16 00:00:00 | 2012-05-16 00:00:00
114 | 2012-08-14 00:00:00 | 2012-05-16 00:00:00 | 2012-05-16 00:00:00
63 | 2012-08-20 00:00:00 | 2012-05-22 00:00:00 | 2012-05-22 00:00:00
113 | 2012-08-20 00:00:00 | 2012-05-22 00:00:00 | 2012-05-22 00:00:00
162 | 2012-08-27 00:00:00 | 2012-05-29 00:00:00 | 2012-05-29 00:00:00
260 | 2012-08-28 00:00:00 | 2012-05-30 00:00:00 | 2012-05-30 00:00:00
9 | 2012-08-31 00:00:00 | 2012-06-02 00:00:00 | 2012-06-02 00:00:00
10 | 2012-08-31 00:00:00 | 2012-06-02 00:00:00 | 2012-06-02 00:00:00
122 | 2012-09-04 00:00:00 | 2012-06-06 00:00:00 | 2012-06-06 00:00:00
104 | 2012-09-17 00:00:00 | 2012-06-19 00:00:00 | 2012-03-21 00:00:00
137 | 2012-09-29 00:00:00 | 2012-07-01 00:00:00 | 2012-04-02 00:00:00
121 | 2012-10-02 00:00:00 | 2012-07-04 00:00:00 | 2012-07-04 00:00:00
201 | 2012-10-11 00:00:00 | 2012-07-13 00:00:00 | 2012-07-13 00:00:00
351 | 2012-08-05 00:00:00 | 2012-08-05 00:00:00 | 2012-08-05 00:00:00
190 | 2012-11-04 00:00:00 | 2012-08-06 00:00:00 | 2012-08-06 00:00:00
143 | 2012-11-07 00:00:00 | 2012-08-09 00:00:00 | 2012-08-09 00:00:00
164 | 2012-11-07 00:00:00 | 2012-08-09 00:00:00 | 2012-08-09 00:00:00
168 | 2012-11-12 00:00:00 | 2012-08-14 00:00:00 | 2012-08-14 00:00:00
273 | 2012-11-14 00:00:00 | 2012-08-16 00:00:00 | 2012-08-16 00:00:00
81 | 2012-09-30 00:00:00 | 2012-08-31 00:00:00 | 2012-07-02 00:00:00
151 | 2012-12-05 00:00:00 | 2012-09-06 00:00:00 | 2012-12-05 00:00:00
158 | 2012-12-12 00:00:00 | 2012-09-13 00:00:00 | 2012-09-13 00:00:00
124 | 2012-12-14 00:00:00 | 2012-09-15 00:00:00 | 2012-06-17 00:00:00
314 | 2013-01-29 00:00:00 | 2012-10-01 00:00:00 | 2012-10-01 00:00:00
58 | 2012-12-31 00:00:00 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00
288 | 2013-01-30 00:00:00 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00
291 | 2013-01-30 00:00:00 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00
300 | 2013-01-30 00:00:00 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00
305 | 2013-01-30 00:00:00 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00
315 | 2013-01-30 00:00:00 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00
292 | 2013-01-30 00:00:00 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00
293 | 2013-01-30 00:00:00 | 2012-10-02 00:00:00 | 2012-10-02 00:00:00
281 | 2013-01-31 00:00:00 | 2012-10-03 00:00:00 | 2012-10-03 00:00:00
294 | 2013-01-31 00:00:00 | 2012-10-03 00:00:00 | 2012-10-03 00:00:00
297 | 2013-01-31 00:00:00 | 2012-10-03 00:00:00 | 2012-10-03 00:00:00
306 | 2013-01-31 00:00:00 | 2012-10-03 00:00:00 | 2012-10-03 00:00:00
298 | 2013-02-16 00:00:00 | 2012-10-19 00:00:00 | 2013-02-16 00:00:00
79 | 2013-02-28 00:00:00 | 2012-10-31 00:00:00 | 2013-02-28 00:00:00
268 | 2013-01-31 00:00:00 | 2012-11-02 00:00:00 | 2012-11-02 00:00:00
275 | 2013-01-31 00:00:00 | 2012-11-02 00:00:00 | 2012-08-04 00:00:00
59 | 2013-02-05 00:00:00 | 2012-11-07 00:00:00 | 2012-11-07 00:00:00
55 | 2013-02-05 00:00:00 | 2012-11-07 00:00:00 | 2012-11-07 00:00:00
2 | 2012-12-15 00:00:00 | 2012-11-15 00:00:00 | 2012-11-15 00:00:00
301 | 2013-03-19 00:00:00 | 2012-11-19 00:00:00 | 2012-11-19 00:00:00
296 | 2013-03-23 00:00:00 | 2012-11-23 00:00:00 | 2013-03-23 00:00:00
283 | 2013-03-27 00:00:00 | 2012-11-27 00:00:00 | 2012-11-27 00:00:00
344 | 2012-12-31 00:00:00 | 2012-12-01 00:00:00 | 2012-12-01 00:00:00
170 | 2013-01-31 00:00:00 | 2012-12-02 00:00:00 | 2012-12-02 00:00:00
254 | 2013-03-31 00:00:00 | 2012-12-31 00:00:00 | 2012-12-31 00:00:00
160 | 2013-03-31 00:00:00 | 2012-12-31 00:00:00 | 2012-12-31 00:00:00
163 | 2013-03-31 00:00:00 | 2012-12-31 00:00:00 | 2012-12-31 00:00:00
282 | 2013-04-30 00:00:00 | 2012-12-31 00:00:00 | 2012-12-31 00:00:00
308 | 2013-05-01 00:00:00 | 2013-01-01 00:00:00 | 2013-05-01 00:00:00
166 | 2013-04-08 00:00:00 | 2013-01-08 00:00:00 | 2013-01-08 00:00:00
194 | 2013-04-13 00:00:00 | 2013-01-13 00:00:00 | 2013-01-13 00:00:00
196 | 2013-04-13 00:00:00 | 2013-01-13 00:00:00 | 2013-01-13 00:00:00
35 | 2013-08-31 00:00:00 | 2013-06-02 00:00:00 | 2013-06-02 00:00:00
101 | 2013-08-31 00:00:00 | 2013-06-02 00:00:00 | 2013-06-02 00:00:00
145 | 2013-08-31 00:00:00 | 2013-06-02 00:00:00 | 2013-06-02 00:00:00
20 | 2013-08-31 00:00:00 | 2013-06-02 00:00:00 | 2013-06-02 00:00:00
46 | 2013-08-31 00:00:00 | 2013-06-02 00:00:00 | 2013-06-02 00:00:00
103 | 2013-09-30 00:00:00 | 2013-06-02 00:00:00 | 2013-06-02 00:00:00
179 | 2013-09-30 00:00:00 | 2013-06-02 00:00:00 | 2013-06-02 00:00:00
387 | 2013-09-30 00:00:00 | 2013-06-02 00:00:00 | 2013-06-02 00:00:00
75 | 2013-09-01 00:00:00 | 2013-06-03 00:00:00 | 2013-06-03 00:00:00
119 | 2013-10-31 00:00:00 | 2013-08-02 00:00:00 | 2013-08-02 00:00:00
120 | 2013-10-31 00:00:00 | 2013-08-02 00:00:00 | 2013-08-02 00:00:00
221 | 2013-09-30 00:00:00 | 2013-08-31 00:00:00 | 2013-08-31 00:00:00
17 | 2014-01-14 00:00:00 | 2013-10-16 00:00:00 | 2013-10-16 00:00:00
61 | 2014-01-31 00:00:00 | 2013-11-02 00:00:00 | 2013-11-02 00:00:00
51 | 2014-01-31 00:00:00 | 2013-11-02 00:00:00 | 2013-11-02 00:00:00
132 | 2014-02-28 00:00:00 | 2013-11-30 00:00:00 | 2013-11-30 00:00:00
385 | 2014-03-03 00:00:00 | 2013-12-03 00:00:00 | 2013-12-03 00:00:00
71 | 2014-04-03 00:00:00 | 2013-12-04 00:00:00 | 2014-04-03 00:00:00
87 | 2014-04-10 00:00:00 | 2013-12-11 00:00:00 | 2013-12-11 00:00:00
89 | 2014-05-23 00:00:00 | 2014-01-23 00:00:00 | 2014-01-23 00:00:00
319 | 2014-05-28 00:00:00 | 2014-01-28 00:00:00 | 2014-01-28 00:00:00
90 | 2014-08-23 00:00:00 | 2014-04-25 00:00:00 | 2014-04-25 00:00:00
216 | 2014-05-31 00:00:00 | 2014-05-01 00:00:00 | 2014-05-01 00:00:00
45 | 2014-07-31 00:00:00 | 2014-05-02 00:00:00 | 2014-05-02 00:00:00
217 | 2014-06-14 00:00:00 | 2014-05-15 00:00:00 | 2014-05-15 00:00:00
404 | 2014-08-21 00:00:00 | 2014-05-23 00:00:00 | 2014-05-23 00:00:00
218 | 2014-08-29 00:00:00 | 2014-05-31 00:00:00 | 2014-05-31 00:00:00
8 | 2014-08-31 00:00:00 | 2014-06-02 00:00:00 | 2014-06-02 00:00:00
3 | 2014-08-31 00:00:00 | 2014-06-02 00:00:00 | 2014-06-02 00:00:00
99 | 2014-08-31 00:00:00 | 2014-06-02 00:00:00 | 2014-06-02 00:00:00
211 | 2014-09-07 00:00:00 | 2014-06-09 00:00:00 | 2014-06-09 00:00:00
205 | 2014-09-20 00:00:00 | 2014-06-22 00:00:00 | 2014-06-22 00:00:00
44 | 2014-10-31 00:00:00 | 2014-08-02 00:00:00 | 2014-08-02 00:00:00
70 | 2014-12-06 00:00:00 | 2014-08-08 00:00:00 | 2014-08-08 00:00:00
100 | 2014-11-30 00:00:00 | 2014-09-01 00:00:00 | 2014-09-01 00:00:00
50 | 2014-11-30 00:00:00 | 2014-09-01 00:00:00 | 2014-09-01 00:00:00
128 | 2014-12-14 00:00:00 | 2014-09-15 00:00:00 | 2014-06-17 00:00:00
41 | 2014-12-31 00:00:00 | 2014-10-02 00:00:00 | 2014-10-02 00:00:00
23 | 2014-12-31 00:00:00 | 2014-10-02 00:00:00 | 2014-10-02 00:00:00
192 | 2015-01-02 00:00:00 | 2014-10-04 00:00:00 | 2014-10-04 00:00:00
18 | 2015-01-03 00:00:00 | 2014-10-05 00:00:00 | 2014-10-05 00:00:00
19 | 2015-01-09 00:00:00 | 2014-10-11 00:00:00 | 2014-10-11 00:00:00
28 | 2015-03-15 00:00:00 | 2014-12-15 00:00:00 | 2014-12-15 00:00:00
169 | 2015-03-31 00:00:00 | 2014-12-31 00:00:00 | 2014-12-31 00:00:00
391 | 2015-05-01 00:00:00 | 2015-04-01 00:00:00 | 2015-04-01 00:00:00
377 | 2015-08-01 00:00:00 | 2015-07-02 00:00:00 | 2015-08-01 00:00:00
66 | 2015-10-31 00:00:00 | 2015-08-02 00:00:00 | 2015-08-02 00:00:00
389 | 2015-12-02 00:00:00 | 2015-08-04 00:00:00 | 2015-08-04 00:00:00
154 | 2015-10-24 00:00:00 | 2015-08-25 00:00:00 | 2015-08-25 00:00:00
208 | 2015-12-31 00:00:00 | 2015-09-02 00:00:00 | 2015-09-02 00:00:00
155 | 2015-11-06 00:00:00 | 2015-09-07 00:00:00 | 2015-09-07 00:00:00
30 | 2016-03-01 00:00:00 | 2015-11-02 00:00:00 | 2015-11-02 00:00:00
5 | 2016-03-31 00:00:00 | 2015-12-02 00:00:00 | 2015-12-02 00:00:00
6 | 2016-03-31 00:00:00 | 2015-12-02 00:00:00 | 2015-12-02 00:00:00
402 | 2016-04-10 00:00:00 | 2015-12-12 00:00:00 | 2015-12-12 00:00:00
152 | 2016-04-21 00:00:00 | 2015-12-23 00:00:00 | 2015-12-23 00:00:00
165 | 2016-04-21 00:00:00 | 2015-12-23 00:00:00 | 2015-12-23 00:00:00
36 | 2016-04-30 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00
31 | 2016-04-30 00:00:00 | 2016-01-01 00:00:00 | 2016-01-01 00:00:00
207 | 2016-05-01 00:00:00 | 2016-01-02 00:00:00 | 2016-01-02 00:00:00
147 | 2016-05-19 00:00:00 | 2016-01-20 00:00:00 | 2016-04-19 00:00:00
42 | 2016-05-03 00:00:00 | 2016-02-03 00:00:00 | 2016-02-03 00:00:00
252 | 2016-02-15 00:00:00 | 2016-02-15 00:00:00 | 2015-11-17 00:00:00
253 | 2016-02-15 00:00:00 | 2016-02-15 00:00:00 | 2015-11-17 00:00:00
65 | 2016-07-14 00:00:00 | 2016-03-16 00:00:00 | 2016-03-16 00:00:00
150 | 2016-05-31 00:00:00 | 2016-04-01 00:00:00
84 | 2016-05-09 00:00:00 | 2016-04-09 00:00:00 | 2016-04-09 00:00:00
16 | 2016-09-30 00:00:00 | 2016-07-02 00:00:00
405 | 2016-12-04 00:00:00 | 2016-08-06 00:00:00 | 2016-08-06 00:00:00
80 | 2017-04-03 00:00:00 | 2017-01-03 00:00:00 | 2017-01-03 00:00:00
29 | 2022-01-03 00:00:00 | 2021-11-04 00:00:00 | 2021-11-04 00:00:00
341 | 2023-04-30 00:00:00 | 2023-04-30 00:00:00 | 2022-04-30 00:00:00
338 | 2012-05-31 00:00:00 |  | 2012-05-31 00:00:00
270 | 2012-07-12 00:00:00
202 | 2013-01-31 00:00:00 |  | 2012-10-03 00:00:00
304 | 2013-02-19 00:00:00 |  | 2012-10-22 00:00:00
25 | 2013-02-28 00:00:00 |  | 2012-11-30 00:00:00
357 | 2013-03-01 00:00:00 |  | 2013-03-01 00:00:00
355 | 2013-08-15 00:00:00 |  | 2013-04-17 00:00:00
345 | 2013-09-29 00:00:00 |  | 2013-09-29 00:00:00
376 | 2013-10-28 00:00:00 |  | 2013-10-28 00:00:00
380 | 2013-10-28 00:00:00 |  | 2013-10-28 00:00:00
379 | 2013-10-28 00:00:00 |  | 2013-10-28 00:00:00
339 | 2013-10-28 00:00:00 |  | 2013-10-28 00:00:00
342 | 2013-10-28 00:00:00 |  | 2013-10-28 00:00:00
343 | 2013-10-28 00:00:00 |  | 2013-10-28 00:00:00
349 | 2013-10-28 00:00:00 |  | 2013-10-28 00:00:00
352 | 2013-10-28 00:00:00 |  | 2013-10-28 00:00:00
353 | 2013-10-28 00:00:00 |  | 2013-10-28 00:00:00
354 | 2013-10-28 00:00:00 |  | 2013-10-28 00:00:00
381 | 2013-10-28 00:00:00 |  | 2013-10-28 00:00:00
346 | 2013-10-31 00:00:00 |  | 2013-10-31 00:00:00
26 | 2014-03-30 00:00:00 |  | 2013-12-30 00:00:00
276 | 2014-04-14 00:00:00 |  | 2014-04-14 00:00:00
38 | 2014-04-30 00:00:00 |  | 2014-04-30 00:00:00
335 | 2014-06-30 00:00:00
334 | 2014-06-30 00:00:00
350 | 2014-08-31 00:00:00 |  | 2014-08-31 00:00:00
233 | 2014-11-30 00:00:00 |  | 2014-09-01 00:00:00
407 | 2015-01-04 00:00:00 |  | 2014-09-06 00:00:00
67 | 2015-01-31 00:00:00
238 | 2015-01-31 00:00:00 |  | 2014-10-03 00:00:00
366 | 2015-01-31 00:00:00 |  | 2014-11-02 00:00:00
332 | 2015-02-28 00:00:00 |  | 2014-10-31 00:00:00
347 | 2015-02-28 00:00:00 |  | 2014-10-31 00:00:00
235 | 2015-04-19 00:00:00 |  | 2015-01-19 00:00:00
236 | 2015-04-19 00:00:00 |  | 2015-01-19 00:00:00
131 | 2015-04-19 00:00:00 |  | 2015-01-19 00:00:00
239 | 2015-04-19 00:00:00 |  | 2015-01-19 00:00:00
237 | 2015-04-19 00:00:00 |  | 2015-01-19 00:00:00
245 | 2015-04-19 00:00:00 |  | 2015-01-19 00:00:00
241 | 2015-04-19 00:00:00 |  | 2015-01-19 00:00:00
242 | 2015-04-19 00:00:00 |  | 2015-01-19 00:00:00
1 | 2015-04-19 00:00:00 |  | 2015-01-19 00:00:00
125 | 2015-04-19 00:00:00 |  | 2015-01-19 00:00:00
240 | 2015-04-19 00:00:00 |  | 2015-01-19 00:00:00
246 | 2015-04-19 00:00:00 |  | 2015-01-19 00:00:00
185 | 2015-11-30 00:00:00
153 | 2015-11-30 00:00:00
341 | 2015-12-31 00:00:00 |  | 2015-12-31 00:00:00
362 | 2015-12-31 00:00:00 |  | 2015-12-31 00:00:00
188 | 2016-06-24 00:00:00 |  | 2016-02-25 00:00:00
21 | 2016-08-29 00:00:00 |  | 2016-05-31 00:00:00
406 | 2016-11-30 00:00:00 |  | 2016-08-02 00:00:00
358 | 2017-03-25 00:00:00 |  | 2017-03-25 00:00:00
408 | 2017-04-10 00:00:00 |  | 2016-12-11 00:00:00
323 | 2020-04-11 00:00:00 |  | 2019-12-13 00:00:00
244 | 2020-12-31 00:00:00 |  | 2020-09-02 00:00:00
328
176
331
98
144
333
177
337
180
325
178
371
382
399
395
388
4 |  |  | 1899-09-01 00:00:00
398
394
62
94
181
78
258
373
182
197
156
248
401
96
40
157
93
392
396
105
322
279
83
280
400
138
251
220
321
311
284
286
317
290
295
285
299
302
303
312
309
310
27
403
0
37
175
374
108
109
383
397
375
184
359
360
361
174
364
24
365
393
372
369
320