title: Look up a date value from each cell in a column and return a year date dependent upon where date falls between two dates
body: <p>I'm wanting to add formula to locate the Policy Year in each cell in column B (starting in B2) which is determined from interrogating the date shown in the corresponding cell in Column A and then checking whether it sits in a range (inception date and expiry date) D2:E5 The Policy Year sits in C2:C5 I've shown the values I'd expect the formula in the cells in column B to draw from Column C.</p>
  
  <p>COLUMN A          COLUMN B   EXPECTED VALUE   COLUMN C     COLUMN D          COLUMN E<br>
  2 April 2017                 2016             2016         5 December 2016   4 December 2017<br>
  5 June 2017                  2016             2017         5 December 2017   4 December 2018<br>
  6 December 2017              2017             2018         5 December 2018   4 December 2019<br>
  4 January 2018               2017             2019         5 December 2019   4 December 2020<br>
  6 August 2018                2017
  4 December 2018              2017
  29 December 2018             2018
  6 March 2020                 2019                                             </p>