Spreadsheet: 600365d1543631705-trying-populate-nonrepeating-dates-based-on-date-range-and-specific-name-vehicle-info-example
Sheet: All Vehicles Record 2017

Vehicle | Date | Driver Name | Beginning Mileage | Ending Mileage | [NAME] | Gas Purchase Amount | Notes
CARGO 4 | 2017-06-27 00:00:00 | [NAME] | 4473 | 4476 |  | 0
CARGO 4 | 2017-06-28 00:00:00 | [NAME] | 4476 | 4519 |  | 0
CARGO 4 | 2017-07-07 00:00:00 | [NAME] | 4519 | 4543 |  | 0
CARGO 4 | 2017-07-10 00:00:00 | [NAME] | 4543 | 4582 |  | 18.01
CARGO 4 | 2017-07-14 00:00:00 | [NAME] | 4582 | 4586 |  | 0
CARGO 4 | 2017-07-17 00:00:00 | [NAME] | 4586 | 4625 |  | 0
CARGO 4 | 2017-07-21 00:00:00 | [NAME] | 4625 | 4628 |  | 0
CARGO 4 | 2017-07-24 00:00:00 | [NAME] | 4628 | 4667 |  | 26
CARGO 4 | 2017-07-26 00:00:00 | [NAME] | 4667 | 4670 |  | 0
CARGO 4 | 2017-07-27 00:00:00 | [NAME] | 4670 | 4709 |  | 0
CARGO 4 | 2017-08-14 00:00:00 | [NAME] | 4710 | 4900 |  | 0
CARGO 4 | 2017-08-24 00:00:00 | [NAME] | 4900 | 4901 |  | 42.54
CARGO 5 | 2017-06-27 00:00:00 | [NAME] | 1034 | 1037 |  | 0
CARGO 5 | 2017-07-03 00:00:00 | [NAME] | 1037 | 1184 |  | 39.48
CARGO 5 | 2017-07-07 00:00:00 | [NAME] | 1184 | 1187 |  | 0
CARGO 5 | 2017-07-10 00:00:00 | [NAME] | 1187 | 1328 |  | 24.68
CARGO 5 | 2017-07-14 00:00:00 | [NAME] | 1328 | 1339 |  | 0
CARGO 5 | 2017-07-17 00:00:00 | [NAME] | 1339 | 1478 |  | 20.09
CARGO 5 | 2017-07-21 00:00:00 | [NAME] | 1478 | 1481 |  | 0
CARGO 5 | 2017-07-24 00:00:00 | [NAME] | 1481 | 1620 |  | 30.76
CARGO 5 | 2017-07-27 00:00:00 | [NAME] | 1620 | 1623 |  | 0
CARGO 5 | 2017-07-31 00:00:00 | [NAME] | 1623 | 1870 |  | 46.17
CARGO 5 | 2017-08-08 00:00:00 | [NAME] | 1870 | 1922 |  | 0
CARGO 5 | 2017-08-09 00:00:00 | [NAME] | 1922 | 1952 |  | 0
CARGO 5 | 2017-08-10 00:00:00 | [NAME] | 1952 | 1982 |  | 0
CARGO 5 | 2017-08-11 00:00:00 | [NAME] | 1982 | 2012 |  | 0
CARGO 5 | 2017-08-14 00:00:00 | [NAME] | 2012 | 2118 |  | 25.05
CARGO 5 | 2017-08-15 00:00:00 | [NAME] | 2118 | 2175 |  | 0
CARGO 5 | 2017-08-15 00:00:00 | [NAME] | 2175 | 2278 |  | 0
CARGO 5 | 2017-08-21 00:00:00 | [NAME] | 2278 | 2381 |  | 56.99
CARGO 5 | 2017-08-21 00:00:00 | [NAME] | 2381 | 2484 |  | 0
CARGO 5 | 2017-08-22 00:00:00 | [NAME] | 2484 | 2484 |  | 35.39
CARGO 5 | 2017-08-23 00:00:00 | [NAME] | 2484 | 2673 |  | 0
CARGO 5 | 2017-08-24 00:00:00 | [NAME] | 2673 | 2674 |  | 35.96
CARGO 6 | 2017-06-27 00:00:00 | [NAME] | 8189 | 8193 |  | 0
CARGO 6 | 2017-07-03 00:00:00 | [NAME] | 8193 | 8431 |  | 0
CARGO 6 | 2017-07-05 00:00:00 | [NAME] | 8431 | 8435 |  | 54
CARGO 6 | 2017-07-07 00:00:00 | [NAME] | 8435 | 8438 |  | 0
CARGO 6 | 2017-07-10 00:00:00 | [NAME] | 8438 | 8664 |  | 39.85
CARGO 6 | 2017-07-15 00:00:00 | Akeem Terry | 8665 | 8675 |  | 0
CARGO 6 | 2017-07-17 00:00:00 | [NAME] | 8675 | 8891 |  | 41.03
CARGO 6 | 2017-07-21 00:00:00 | [NAME] | 8891 | 8895 |  | 0
CARGO 6 | 2017-07-24 00:00:00 | [NAME] | 8895 | 9116 |  | 40.02
CARGO 6 | 2017-07-27 00:00:00 | [NAME] | 9116 | 9120 |  | 0
CARGO 6 | 2017-07-31 00:00:00 | [NAME] | 9120 | 9123 |  | 0
FLOAT 8 | 2017-05-17 00:00:00 | [NAME] | 59788 | 59889 |  | 0
FLOAT 8 | 2017-05-18 00:00:00 | [NAME] | 59889 | 60061 |  | 0
FLOAT 8 | 2017-05-19 00:00:00 | [NAME] | 60061 | 60175 |  | 37.35
FLOAT 8 | 2017-05-22 00:00:00 | [NAME] | 60175 | 60316 |  | 0
FLOAT 8 | 2017-05-23 00:00:00 | [NAME] | 60316 | 60457 |  | 0
FLOAT 8 | 2017-05-24 00:00:00 | [NAME] | 60457 | 60546 |  | 40.91
FLOAT 8 | 2017-05-30 00:00:00 | Amber [NAME] | 60546 | 60694 |  | 0
FLOAT 8 | 2017-06-13 00:00:00 | Amber [NAME] | 60700 | 60846 |  | 0
FLOAT 8 | 2017-06-13 00:00:00 | [NAME] | 60846 | 60897 |  | 0
FLOAT 8 | 2017-06-14 00:00:00 | [NAME] | 60897 | 61099 |  | 42.69
FLOAT 8 | 2017-06-15 00:00:00 | [NAME] | 61099 | 61281 |  | 0
FLOAT 8 | 2017-06-16 00:00:00 | [NAME] | 61281 | 61463 |  | 37.66
FLOAT 8 | 2017-06-19 00:00:00 | [NAME] | 61463 | 61665 |  | 0
FLOAT 8 | 2017-06-20 00:00:00 | [NAME] | 61665 | 61815 |  | 0
FLOAT 8 | 2017-07-03 00:00:00 | [NAME] | 61815 | 62096 |  | 41.37
FLOAT 8 | 2017-07-06 00:00:00 | Amber [NAME] | 62096 | 62222 |  | 0
FLOAT 8 | 2017-07-28 00:00:00 | [NAME] | 62222 | 62330 |  | 48.39
FLOAT 8 | 2017-07-28 00:00:00 | [NAME] | 62330 | 62430 |  | 0
FLOAT 8 | 2017-08-08 00:00:00 | [NAME] | 62430 | 62546 |  | 46.73
FLOAT 8 | 2017-08-09 00:00:00 | [NAME] | 62546 | 62713 |  | 0
FLOAT 8 | 2017-08-10 00:00:00 | [NAME] | 62713 | 62833 |  | 0
FLOAT 8 | 2017-08-15 00:00:00 | [NAME] | 62833 | 62941 |  | 0
FLOAT 8 | 2017-08-16 00:00:00 | [NAME] | 62941 | 63011 |  | 0
FLOAT 8 | 2017-08-16 00:00:00 | [NAME] | 63011 | 63196 |  | 42.29
FLOAT 8 | 2017-08-17 00:00:00 | [NAME] | 63196 | 63381 |  | 0
FLOAT 8 | 2017-08-18 00:00:00 | [NAME] | 63381 | 63465
FLOAT 8 | 2017-08-21 00:00:00 | [NAME] | 63465 | 63533 |  | 0
FLOAT 8 | 2017-08-21 00:00:00 | [NAME] | 63533 | 63601 |  | 0
FLOAT 8 | 2017-08-22 00:00:00 | [NAME] | 63601 | 63741 |  | 43.87
FLOAT 8 | 2017-08-23 00:00:00 | [NAME] | 63741 | 63881 |  | 0
FLOAT 8 | 2017-08-24 00:00:00 | [NAME] | 63881 | 63882 |  | 23.69
FLOAT 9 | 2017-05-22 00:00:00 | Amber [NAME] | 36396 | 36617 |  | 0
FLOAT 9 | 2017-05-30 00:00:00 | [NAME] | 36617 | 36842 |  | 39
FLOAT 9 | 2017-06-13 00:00:00 | [NAME] | 36842 | 37077 |  | 0
FLOAT 9 | 2017-06-16 00:00:00 | [NAME] | 37077 | 37116 |  | 40
FLOAT 9 | 2017-06-29 00:00:00 | Amber [NAME] | 37116 | 37161 |  | 0
FLOAT 9 | 2017-06-30 00:00:00 | Amber [NAME] | 37161 | 37654 |  | 34.88
FLOAT 9 | 2017-07-03 00:00:00 | Amber [NAME] | 37654 | 37797 |  | 25.63
FLOAT 9 | 2017-07-06 00:00:00 | [NAME] | 37797 | 37923 |  | 34.35
FLOAT 9 | 2017-07-11 00:00:00 | [NAME] | 37923 | 38049 |  | 0
FLOAT 9 | 2017-07-13 00:00:00 | [NAME] | 38049 | 38053 |  | 0
FLOAT 9 | 2017-07-14 00:00:00 | [NAME] | 38053 | 38056 |  | 0
FLOAT 9 | 2017-07-25 00:00:00 | [NAME] | 38056 | 38255 |  | 0
FLOAT 9 | 2017-07-28 00:00:00 | Amber [NAME] | 38255 | 38382 |  | 41.68
FLOAT 9 | 2017-07-31 00:00:00 | [NAME] | 38386 | 38400 |  | 0
FLOAT 9 | 2017-08-15 00:00:00 | [NAME] | 38332 | 38538 |  | 0
FLOAT 9 | 2017-08-17 00:00:00 | [NAME] | 38538 | 38750 |  | 0
FLOAT 9 | 2017-08-21 00:00:00 | Amber [NAME] | 38750 | 38952 |  | 45.91
FLOAT 9 | 2017-08-24 00:00:00 | [NAME] | 38952 | 38953 |  | 16.27
VAN 1 | 2017-04-05 00:00:00 | [NAME] | 21984 | 22202 |  | 0
VAN 1 | 2017-04-18 00:00:00 | [NAME] | 22202 | 22233 |  | 0
VAN 1 | 2017-04-19 00:00:00 | Amber [NAME] |  |  |  | 0 | Flat Tire; Enterprise fixed
VAN 1 | 2017-05-02 00:00:00 | [NAME] | 22238 | 22425 |  | 53
VAN 1 | 2017-05-11 00:00:00 | [NAME] | 22425 | 22435 |  | 0
VAN 1 | 2017-05-16 00:00:00 | [NAME] | 22435 | 22642 |  | 49
VAN 1 | 2017-05-17 00:00:00 | [NAME] | 22642 | 22792 |  | 0
VAN 1 | 2017-05-18 00:00:00 | [NAME] | 22792 | 22962 |  | 41
VAN 1 | 2017-05-19 00:00:00 | [NAME] | 22962 | 23078 |  | 0
VAN 1 | 2017-05-22 00:00:00 | [NAME] | 23078 | 23209 |  | 45
VAN 1 | 2017-05-23 00:00:00 | [NAME] | 23209 | 23338 |  | 0
VAN 1 | 2017-05-30 00:00:00 | [NAME] | 23338 | 23551 |  | 42.59
VAN 1 | 2017-06-14 00:00:00 | [NAME] | 23553 | 23756 |  | 34
VAN 1 | 2017-06-15 00:00:00 | [NAME] | 23756 | 23955 |  | 47.01
VAN 1 | 2017-06-19 00:00:00 | [NAME] | 23955 | 24146 |  | 0
VAN 1 | 2017-06-27 00:00:00 | [NAME] | 24146 | 24147 |  | 46.16
VAN 1 | 2017-06-27 00:00:00 | Marques Pullum | 24147 | 24150 |  | 0
VAN 1 | 2017-07-03 00:00:00 | Marques Pullum | 24150 | 24376 |  | 31.13
VAN 1 | 2017-07-07 00:00:00 | Akeem Terry | 24376 | 24379 |  | 0
VAN 1 | 2017-07-10 00:00:00 | Marques Pullum | 24379 | 24602 |  | 28.48
VAN 1 | 2017-07-14 00:00:00 | [NAME] | 24602 | 24612 |  | 0
VAN 1 | 2017-07-17 00:00:00 | Marques Pullum | 24612 | 24833 |  | 34
VAN 1 | 2017-07-21 00:00:00 | [NAME] | 24833 | 24836 |  | 0
VAN 1 | 2017-07-24 00:00:00 | Marques Pullum | 24836 | 25058 |  | 34
VAN 1 | 2017-08-04 00:00:00 | Amber [NAME] | 25058 | 25320 |  | 0
VAN 1 | 2017-08-15 00:00:00 | [NAME] | 25320 | 25373 |  | 51.62
VAN 1 | 2017-08-24 00:00:00 | [NAME] | 25373 | 25626 |  | 40.11
VAN 2 | 2017-04-05 00:00:00 | Amber [NAME] | 34162 | 34284 |  | 0
VAN 2 | 2017-04-18 00:00:00 | Amber [NAME] | 34284 | 34314 |  | 0
VAN 2 | 2017-04-20 00:00:00 | [NAME] | 34314 | 34326 |  | 0
VAN 2 | 2017-04-25 00:00:00 | [NAME] | 34326 | 34373 |  | 0
VAN 2 | 2017-04-26 00:00:00 | Amber [NAME] | 34373 | 34379 |  | 0
VAN 2 | 2017-04-28 00:00:00 | Amber [NAME] | 34379 | 34389 |  | 0
VAN 2 | 2017-05-02 00:00:00 | Amber [NAME] | 34389 | 34587 |  | 35.76
VAN 2 | 2017-05-03 00:00:00 | Amber [NAME] | 34587 | 34675 |  | 0
VAN 2 | 2017-05-04 00:00:00 | Amber [NAME] | 34675 | 34681 |  | 0
VAN 2 | 2017-05-05 00:00:00 | Amber [NAME] | 34681 | 34707 |  | 0
VAN 2 | 2017-05-17 00:00:00 | [NAME] | 34707 | 34709 |  | 48
VAN 2 | 2017-05-17 00:00:00 | Amber [NAME] | 34709 | 34879 |  | 0
VAN 2 | 2017-05-18 00:00:00 | [NAME] | 34879 | 34880 |  | 24.48
VAN 2 | 2017-05-22 00:00:00 | [NAME] | 34880 | 35183 |  | 47.01
VAN 2 | 2017-05-23 00:00:00 | Amber [NAME] | 35183 | 35436 |  | 0
VAN 2 | 2017-06-02 00:00:00 | Amber [NAME] |  |  |  | 0 | Windshield Repair
VAN 2 | 2017-06-27 00:00:00 | [NAME] | 35445 | 35448 |  | 0
VAN 2 | 2017-06-28 00:00:00 | [NAME] | 35448 | 35470 |  | 0
VAN 2 | 2017-07-05 00:00:00 | Amber [NAME] | 35470 | 35482 |  | 0
VAN 2 | 2017-07-07 00:00:00 | Akeem Terry | 35482 | 35485 |  | 0
VAN 2 | 2017-07-10 00:00:00 | [NAME] | 35485 | 35509 |  | 0
VAN 2 | 2017-07-14 00:00:00 | [NAME] | 35509 | 35512 |  | 0
VAN 2 | 2017-07-17 00:00:00 | [NAME] | 35512 | 35533 |  | 0
VAN 2 | 2017-07-21 00:00:00 | [NAME] | 35533 | 35536 |  | 0
VAN 2 | 2017-07-24 00:00:00 | [NAME] | 35536 | 35558 |  | 0
VAN 2 | 2017-07-26 00:00:00 | Akeem Terry | 35558 | 35561 |  | 0
VAN 2 | 2017-07-27 00:00:00 | [NAME] | 35561 | 35582 |  | 0
VAN 2 | 2017-08-08 00:00:00 | [NAME] | 35582 | 35584 |  | 29.17
VAN 2 | 2017-08-09 00:00:00 | [NAME] | 35584 | 35705 |  | 0
VAN 2 | 2017-08-10 00:00:00 | [NAME] | 35705 | 35824 |  | 0
VAN 2 | 2017-08-11 00:00:00 | [NAME] | 35824 | 36322 |  | 50.01
VAN 2 | 2017-08-15 00:00:00 |  | 36322 | 36322 |  | 38.53
VAN 3 | 2017-04-04 00:00:00 | [NAME] | 24931 | 24982 |  | 0
VAN 3 | 2017-04-05 00:00:00 | [NAME] | 24982 | 25075 |  | 0
VAN 3 | 2017-04-24 00:00:00 | [NAME] | 25075 | 25077 |  | 23
VAN 3 | 2017-04-25 00:00:00 | [NAME] | 25077 | 25283 |  | 0
VAN 3 | 2017-05-02 00:00:00 | [NAME] | 25283 | 25369 |  | 0
VAN 3 | 2017-05-16 00:00:00 | [NAME] | 25369 | 25413 |  | 43.45
VAN 3 | 2017-05-25 00:00:00 | [NAME] | 25413 | 25418 |  | 0
VAN 3 | 2017-05-30 00:00:00 | [NAME] | 25418 | 25482 |  | 0
VAN 3 | 2017-06-13 00:00:00 | [NAME] | 25483 | 25589 |  | 0
VAN 3 | 2017-06-14 00:00:00 | [NAME] | 25589 | 25765 |  | 29
VAN 3 | 2017-06-15 00:00:00 | Amber [NAME] | 25765 | 25987 |  | 40.65
VAN 3 | 2017-06-19 00:00:00 | Amber [NAME] | 25987 | 26177 |  | 0
VAN 3 | 2017-06-26 00:00:00 | [NAME] | 26177 | 26196 |  | 0
VAN 3 | 2017-06-27 00:00:00 | [NAME] | 26196 | 26197 |  | 43
VAN 3 | 2017-06-27 00:00:00 | Akeem Terry | 26197 | 26200 |  | 0
VAN 3 | 2017-06-28 00:00:00 | Akeem Terry | 26200 | 26232 |  | 0
VAN 3 | 2017-06-30 00:00:00 | Avery Giannoulis | 26232 | 26369 |  | 0
VAN 3 | 2017-07-05 00:00:00 | [NAME] | 26369 | 26420 |  | 0
VAN 3 | 2017-07-07 00:00:00 | Akeem Terry | 26420 | 26424 |  | 0
VAN 3 | 2017-07-10 00:00:00 | Akeem Terry | 26424 | 26459 |  | 38.18
VAN 3 | 2017-07-15 00:00:00 | Akeem Terry | 26459 | 26462 |  | 0
VAN 3 | 2017-07-17 00:00:00 | Akeem Terry | 26462 | 26496 |  | 0
VAN 3 | 2017-07-21 00:00:00 | [NAME] | 26496 | 26499 |  | 0
VAN 3 | 2017-07-24 00:00:00 | Akeem Terry | 26499 | 26532 |  | 0
VAN 3 | 2017-07-26 00:00:00 | [NAME] | 26532 | 26535 |  | 0
VAN 3 | 2017-07-27 00:00:00 | Akeem Terry | 26535 | 26567 |  | 21.07
VAN 3 | 2017-07-28 00:00:00 | [NAME] | 26567 | 26702 |  | 0
VAN 3 | 2017-08-02 00:00:00 | [NAME] | 26702 | 26828 |  | 0
VAN 3 | 2017-08-08 00:00:00 | [NAME] | 26828 | 26830 |  | 32.58
VAN 3 | 2017-08-11 00:00:00 | Amber [NAME] | 26830 | 26951 |  | 0
VAN 3 | 2017-08-14 00:00:00 | Amber [NAME] | 26951 | 27135 |  | 0
VAN 3 | 2017-08-15 00:00:00 | Amber [NAME] | 27135 | 27328 |  | 43.52
VAN 3 | 2017-08-16 00:00:00 | [NAME] | 27328 | 27505 |  | 44.8
VAN 3 | 2017-08-18 00:00:00 | [NAME] | 27505 | 27622 |  | 0
VAN 3 | 2017-08-24 00:00:00 | [NAME] | 27622 | 27623 |  | 21.47