Spreadsheet: 873787d1720356592-creating-a-list-from-between-2-dates-dean-gilgrist-sample-final-with-examples-
Sheet: LEADBANK

Leadbank |  |  |  |  |  | ex VAT
Customer | Reference | Product 1 DATE | Product 2 DATE | Fit 1 DATE | Fit 2 DATE | Product 1 Value | Product 2 VALUE | Fit 1 Value | Fit 2 Value
(Customer Details)
[NAME] | Kitchen | N/A | 2024-01-15 00:00:00 | N/A | 2024-01-15 00:00:00 | 33 | 33 | 1400 | 1400
[NAME] * | Flooring | N/A | N/A | N/A | 2024-01-19 00:00:00 | 0 | 0 | 333 | 333
[NAME] | Repairs | N/A | N/A | N/A | 2024-01-23 00:00:00 | 0 | 0 | 250 | 250
[NAME] * | Master & Casper | 2023-11-29 00:00:00 | 2023-12-12 00:00:00 | N/A | 2024-01-28 00:00:00 | 5016 | 2638 | 933 | 933
[NAME] * | Master [NAME] | 2024-01-05 00:00:00 | 2024-01-28 00:00:00 | N/A | 2024-02-05 00:00:00 | 2048 | 1421 | 600 | 600
[NAME] | Wk 4 | N/A | N/A | 2024-02-02 00:00:00 | 2024-02-09 00:00:00 | 0 | 0 | 1800 | 1800
[NAME] | Boxing | N/A | 2024-02-10 00:00:00 | N/A | 2024-02-10 00:00:00 | 50 | 41 | 200 | 200
[NAME] | Wk 6 | N/A | N/A | N/A | 2024-02-16 00:00:00 | 0 | 0 | 200 | 200
[NAME] | Wk 6 | N/A | N/A | N/A | 2024-02-16 00:00:00 | 0 | 0 | 400 | 400
[NAME] * | Master [NAME] | 2024-01-07 00:00:00 | 2024-02-16 00:00:00 | N/A | 2024-02-21 00:00:00 | 1835 | 0 | 700 | 700
Adam | Airing | 2024-02-07 00:00:00 | 2024-02-13 00:00:00 | N/A | 2024-03-11 00:00:00 | 874 | 0 | 620 | 620
[NAME] | Wk 9 | N/A | N/A | N/A | 2024-03-15 00:00:00 | 0 | 0 | 350 | 350
[NAME] * | Master [NAME] | 2023-11-05 00:00:00 | 2024-03-10 00:00:00 | N/A | 2024-03-21 00:00:00 | 4207 | 0 | 850 | 850
Maskell & Josephson | Kitchen | 2024-02-22 00:00:00 | 2024-03-16 00:00:00 | N/A | 2024-03-25 00:00:00 | 2088 | 0 | 762 | 762
Maskell & Josephson | Showroom | 2024-02-22 00:00:00 | 2024-03-02 00:00:00 | N/A | 2024-03-25 00:00:00 | 3100 | 0 | 850 | 850
Geo & Jen | Master [NAME] | 2024-03-13 00:00:00 | 2024-03-25 00:00:00 | N/A | 2024-03-28 00:00:00 | 1336 | 0 | 450 | 450
Geo & Jen | Kitchen | N/A | N/A | 2024-04-04 00:00:00 | 2024-04-04 00:00:00 | 20 | 0 | 1925 | 1925
Maskell & Josephson | [NAME] | N/A | N/A | 2024-04-06 00:00:00 | 2024-04-06 00:00:00 | 197 | 0 | 350 | 350
[NAME] | Wk 15 | N/A | N/A | N/A | 2024-04-19 00:00:00 | 0 | 0 | 2100 | 2100
Clare | Porch & Understairs | 2024-02-26 00:00:00 | 2024-04-14 00:00:00 | 2024-04-14 00:00:00 | 2024-04-24 00:00:00 | 1529 | 0 | 1150 | 1150
[NAME] | Kitchen | N/A | N/A | N/A | 2024-04-30 00:00:00 | 0 | 0 | 1750 | 1750
Maskell & Josephson | Backboard | N/A | 2024-05-01 00:00:00 | N/A | 2024-05-01 00:00:00 | 197 | 0 | 100 | 100
[NAME] | Alcoves | 2024-04-04 00:00:00 | 2024-04-29 00:00:00 | N/A | 2024-05-03 00:00:00 | 829 | 0 | 550 | 550
[NAME] | Wtops | 2024-02-27 00:00:00 | 2024-04-26 00:00:00 | N/A | 2024-05-14 00:00:00 | 624 | 0 | 800 | 800
[NAME] | Utility | 2024-04-29 00:00:00 | 2024-05-05 00:00:00 | N/A | 2024-05-15 00:00:00 | 1347 | 0 | 1186 | 1186
[NAME] | [NAME] | 2024-05-13 00:00:00 |  |  |  | 2109 | 0 | 1150 | 1150
[NAME] | [NAME] | 2024-05-13 00:00:00 |  |  |  | 4068 | 0 | 1470 | 1470
[NAME] | Master [NAME] | 2024-05-08 00:00:00 | 2024-05-24 00:00:00 | N/A | 2024-05-30 00:00:00 | 1121 | 0 | 625 | 625
[NAME] | Wk 22 | N/A | N/A | N/A | 2024-06-07 00:00:00 | 0 | 0 | 1400 | 1400
[NAME] | Wk 24 | N/A | N/A | N/A | 2024-06-14 00:00:00 | 0 | 0 | 750 | 750
[NAME] | Utility | 2024-05-19 00:00:00 | 2024-06-14 00:00:00 | N/A | 2024-06-18 00:00:00 | 1523 | 0 | 975 | 975
[NAME] | Master [NAME]
[NAME] | Kitchen | 2024-06-04 00:00:00 | 2024-06-06 00:00:00 | 2024-06-25 00:00:00 | 2024-06-26 00:00:00 | 5969 | 3558 | 1926 | 1926
[NAME] | Flooring 2 | 2024-06-26 00:00:00 | 2024-06-26 00:00:00 | N/A | N/A | 1422 | 1030 | 0 | 0
Cheshire Marble | Hocking | N/A | N/A | N/A | 2024-06-27 00:00:00 | 0 | 0 | 200 | 200
Kath & Glynn Jones | [NAME] | N/A | 2024-06-28 00:00:00 | 2024-06-08 00:00:00 | 2024-06-28 00:00:00 | 362 | 163 | 875 | 875
[NAME] | Kitchen |  |  |  |  | 5619 | 3499 | 2030 | 2030
[NAME] | Girls Room | 2024-07-02 00:00:00 |  |  |  | 2394 | 1320 | 800 | 800
[NAME] | Media Wall | 2024-05-19 00:00:00 | 2024-06-17 00:00:00 |  |  | 2246 | 1177 | 800 | 800
[NAME] | Flooring | 2024-06-06 00:00:00 | 2024-06-17 00:00:00 |  |  | 1351 | 1228 | 700 | 700
Kathy | Kitchen
[NAME] | Utility |  |  |  |  | 1071 | 679 | 250 | 250
[NAME] | Sample Stand | N/A | 2024-07-05 00:00:00 | N/A | N/A | 686 | 35 | 0 | 0
[NAME] | Media Wall | 2024-06-14 00:00:00 |  |  |  | 1562 | 942 | 800 | 800
Martina | Under Stairs
Dave & Dawn Currie | Walk In | 2024-07-04 00:00:00 |  |  |  | 4109 | 2334 | 880 | 880
[NAME] | Bedroom | 2024-06-21 00:00:00 |  |  |  | 1208 | 623 | 0 | 0
[NAME] | Eliza & Ezme
[NAME] | Skirts & Arcs | N/A |  |  |  | 696 | 504 | 0 | 0
Clare | Daughter | 2024-06-02 00:00:00 | 2024-07-04 00:00:00 |  |  | 2417 | 977 | 975 | 975
Hooshyar | Master & Man Cave
[NAME] | Master [NAME] | 2024-07-02 00:00:00 |  |  |  | 2565 | 1127 | 900 | 900
Tyrone Fitzgerald | Boiler Housing
[NAME] Long Lane |  | N/A |  |  |  | 0 | 0 | 1225 | 1225
Lynsey Evans | Sons Room |  |  |  |  | 1251 | 533 | 800 | 800
[NAME] | Rostherne Close
[NAME] | Long Lane
[NAME] | Master [NAME] |  |  |  |  | 3096 | 1907 | 1150 | 1150
[NAME] | Master [NAME] |  |  |  |  | 852 | 471 | 450 | 450
Paula & David Lang | Master [NAME] | 2024-06-14 00:00:00 |  |  |  | 3830 | 2341 | 1150 | 1150