Spreadsheet: 186724d1350172842-vlookup-to-return-a-start-date-if-it-falls-between-two-dates-otherwise-leave-blank-sart_12-10-12_sample
Sheet: S360

CSD School Number | ID | Name | Company Name | UK School Name | LA | Company Address | Company Post Code | Company Phone | Subscription STATUS | Centre ID | CSD School Number | Teacher registration link | Subscription Start | Subscription End |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UK - School Type^^Secondary||Primary||MDS||MDP||Special||Other place of education||FE||HE||Teaching School||Non-school |  |  |  |  |  |  |  |  |  |  | Start date Date |  | Renewaldate
20 | 29560565 | Central Foundation Girl's School E3 2AT | Central Foundation Girl's School E3 2AT | Central Foundation Girl's School | Tower Hamlets | Harley Grove Bow  LONDON  E3 2AT | E3 2AT | (020) 8981 1131 | Subscriber Renewal | E3C | 20 |  | 2012-03-05 | 2013-03-04 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secondary
38 | 29558543 | Bishops Bluecoat CE High School CH3 5XF | Bishops Bluecoat CE High School CH3 5XF | Bishops Bluecoat CE High School | Cheshire West and [NAME] | [NAME]  CHESTER  CH3 5XF | CH3 5XF | (01244) 313806 | Subscriber Renewal | CH3BH | 38 |  | 2009-12-19 | 2013-03-18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secondary
59 | 29561167 | The Parker E-Act Academy NN11 0QF | The Parker E-Act Academy NN11 0QF | The Parker E-Act Academy | Northamptonshire | [NAME]   DAVENTRY Northamptonshire NN11 0QF | NN11 0QF | (01327) 705816 | Subscriber Renewal | [NAME] | 59 |  | 2011-09-01 | 2014-08-31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secondary
62 | 29563703 | Derby Moor Community Sports DE23 2FS | Derby Moor Community Sports DE23 2FS | Derby Moor Community Sports | Derby | [NAME]  DERBY  DE23 2FS | DE23 2FS | (01332) 772706 | Subscriber Renewal | DE23DM | 62 |  | 2012-08-17 | 2013-08-16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secondary
66 | 29559844 | Sir Frederic Osborn School AL7 2AF | Sir Frederic Osborn School AL7 2AF | Sir Frederic Osborn School | Hertfordshire | [NAME] Hertfordshire AL7 2AF | AL7 2AF | (0844) 477 2515 | Subscriber Renewal | AL7SF | 66 |  | 2011-08-01 | 2014-07-31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secondary
68 | 29561422 | Yewlands School Technology College S35 8NN | Yewlands School Technology College S35 8NN | Yewlands School Technology College | Sheffield | [NAME]  S35 8NN | S35 8NN | (011) 4232 9010 | Subscriber Renewal | S30Y | 68 |  | 2012-08-01 | 2013-07-31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secondary
75 | 28183121 | Uppingham Community College LE15 9TJ | Uppingham Community College LE15 9TJ | Uppingham Community College | Rutland | London Road Uppingham OAKHAM Leicestershire LE15 9TJ | LE15 9TJ | (01572) 823631 | Subscriber Renewal | LE15UC | 75 |  | 2011-09-19 | 2012-09-18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secondary
83 | 29559289 | Philip Morant School CO3 4QS | Philip Morant School CO3 4QS | Philip Morant School | Essex | [NAME]COLCHESTER  CO3 4QS | CO3 4QS | (01206) 545222 | Subscriber Renewal | CO3P | 83 |  | 2011-02-07 | 2014-02-06 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secondary
91 | 29560009 | Leigh Technology Academy DA1 1QE | Leigh Technology Academy DA1 1QE | Leigh Technology Academy | Kent | Green Street Green Road  DARTFORD  DA1 1QE | DA1 1QE | (01322) 620400 | Subscriber New | DA1LC | 91 |  | 2009-11-08 | 2012-11-07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secondary
97 | 29558370 | Bournville School & Sixth Form B30 1QJ | Bournville School & Sixth Form B30 1QJ | Bournville School & Sixth Form | Birmingham | [NAME]BIRMINGHAM  B30 1QJ | B30 1QJ | (0121) 475 3881 | Subscriber Renewal | B30BS | 97 |  | 2010-02-09 | 2013-02-08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secondary
100 | 29558344 | Harborne Academy B15 3JL | Harborne Academy B15 3JL | Harborne Academy | Birmingham | [NAME]  BIRMINGHAM  B15 3JL | B15 3JL | (0121) 464 2737 | Subscriber Renewal | B15HA | 100 |  | 2010-02-16 | 2013-02-15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secondary
108 | 29562055 | Tong School BD4 6NR | Tong School BD4 6NR | Tong School | Bradford | Wesgate Hill Street Westgate  BRADFORD West Yorkshire BD4 6NR | BD4 6NR | (01274) 681455 | Subscriber Renewal | BD4TU | 108 |  | 2011-03-17 | 2014-03-16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secondary
116 | 29559257 | Chelmer Valley High School CM1 7ER | Chelmer Valley High School CM1 7ER | Chelmer Valley High School | Essex | Court Road Broomfield  CHELMSFORD  CM1 7ER | CM1 7ER | (01245) 440232 | Subscriber Renewal | CM1CV | 116 |  | 2011-03-13 | 2014-03-12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secondary
519 | 29559266 | [NAME] 3NR | [NAME] 3NR | [NAME] | Essex | [NAME]   BRAINTREE Essex CM7 3NR | CM7 3NR | (01376) 321813 | Subscriber Renewal | CM7AH | 519 |  | 2012-09-02 | 2015-09-01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Secondary