Spreadsheet: 694159d1599398523-formula-to-extract-a-value-based-on-a-client-code-match-and-that-fits-within-a-date-range-example-file
Sheet: Sheet2

Student ID | Service Code | Service Start | Service End | Units claimed | Name | School | Units left
BNE5936 | Biology | 2019-08-12 00:00:00 | 2019-08-25 00:00:00 | 2870 | Twinkle | Canterbury
BPV5568 | Biology | 2019-11-18 00:00:00 | 2019-11-24 00:00:00 | 2515 | Coyote | Canterbury
BPV5568 | Biology | 2019-11-18 00:00:00 | 2019-11-24 00:00:00 | 100 | Coyote | Canterbury
BPV5568 | Biology | 2019-12-02 00:00:00 | 2019-12-08 00:00:00 | 1997.5 | Coyote | Canterbury
BPV5568 | Biology | 2019-12-16 00:00:00 | 2019-12-22 00:00:00 | 2572.5 | Coyote | Canterbury
BPV5568 | Biology | 2019-12-30 00:00:00 | 2020-01-05 00:00:00 | 1812.5 | Coyote | Canterbury
BPV5568 | Biology | 2020-01-13 00:00:00 | 2020-01-19 00:00:00 | 1292.5 | Coyote | Canterbury
BPV5568 | Biology | 2020-01-27 00:00:00 | 2020-02-02 00:00:00 | 3140 | Coyote | Canterbury
BPV5568 | Biology | 2020-02-10 00:00:00 | 2020-02-16 00:00:00 | 2975 | Coyote | Canterbury
GFC4323 | Biology | 2019-11-25 00:00:00 | 2019-12-01 00:00:00 | 1782.5 | [NAME] | Canterbury
GFC4323 | Biology | 2019-12-09 00:00:00 | 2019-12-15 00:00:00 | 795 | [NAME] | Canterbury
GFC4323 | Biology | 2019-12-23 00:00:00 | 2019-12-29 00:00:00 | 792.5 | [NAME] | Canterbury
GFC4323 | Science | 2020-01-06 00:00:00 | 2020-01-12 00:00:00 | 1010 | [NAME] | Canterbury
GFC4323 | Biology | 2020-01-20 00:00:00 | 2020-01-26 00:00:00 | 805 | [NAME] | Canterbury
GFC4323 | Biology | 2020-02-03 00:00:00 | 2020-02-09 00:00:00 | 842.5 | [NAME] | Canterbury
GFC4323 | Biology | 2020-02-17 00:00:00 | 2020-02-23 00:00:00 | 817.5 | [NAME] | Canterbury
JFZ8096 | Biology | 2019-07-29 00:00:00 | 2019-08-11 00:00:00 | 1202.5 | [NAME] | Canterbury
JFZ8096 | Biology | 2019-08-12 00:00:00 | 2019-08-25 00:00:00 | 1112.5 | [NAME] | Canterbury
NEX0060 | Biology | 2019-11-04 00:00:00 | 2019-11-10 00:00:00 | 15 | Goofy | Canterbury
NEX0060 | Biology | 2019-11-04 00:00:00 | 2019-11-10 00:00:00 | 92.5 | Goofy | Canterbury
NEX0060 | Maths | 2019-11-04 00:00:00 | 2019-11-10 00:00:00 | 65 | Goofy | Canterbury
NEX0060 | Biology | 2019-11-04 00:00:00 | 2019-11-10 00:00:00 | 27.5 | Goofy | Canterbury
NEX0060 | Biology | 2019-11-18 00:00:00 | 2019-11-24 00:00:00 | 22.5 | Goofy | Canterbury
NEX0060 | Science | 2019-11-18 00:00:00 | 2019-11-24 00:00:00 | 12.5 | Goofy | Canterbury
NEX0060 | Biology | 2019-11-18 00:00:00 | 2019-11-24 00:00:00 | 65 | Goofy | Canterbury
NEX0060 | Maths | 2020-02-10 00:00:00 | 2020-02-16 00:00:00 | 2500 | Goofy | Canterbury
RTL9261 | Science | 2019-10-28 00:00:00 | 2019-11-03 00:00:00 | 45 | Roadrunner | [NAME]
VJE2063 | Biology | 2019-07-29 00:00:00 | 2019-08-11 00:00:00 | 300 | Popeye | Canterbury
VJE2063 | Biology | 2019-08-12 00:00:00 | 2019-08-25 00:00:00 | 340 | Popeye | Canterbury
[NAME] | Maths | 2019-07-31 00:00:00 | 2019-08-06 00:00:00 | 35.5 | [NAME] | St. Marys
[NAME] | Maths | 2020-06-24 00:00:00 | 2020-06-30 00:00:00 | 2.5 | [NAME] | St. Marys
[NAME] | Literacy | 2020-08-02 00:00:00 | 2020-08-08 00:00:00 | 24 | [NAME] | St. Marys
[NAME] | Literacy | 2020-08-02 00:00:00 | 2020-08-08 00:00:00 | 24 | [NAME] | St. Marys
[NAME] | Literacy | 2020-06-24 00:00:00 | 2020-06-30 00:00:00 | 3.5 | [NAME] | St. Marys
[NAME] | Science | 2020-03-03 00:00:00 | 2020-03-09 00:00:00 | 10 | [NAME] | St. Marys