Date match

Hello everyone,

I am trying to find a formula that will populate a cell based on a date range. In the example below column F needs to add the relevant company year based on if the date (in column E) falls in the company year grid. Example:
Screen Shot 2017-12-23 at 17.44.40.jpg

Below, I have manually added in the company years into column F as I cannot work out the formula that will do this for me automatically:
Screen Shot 2017-12-23 at 17.44.31.jpg


And just to further clarify. In the example below 8 February 2019 is between 1 November 2018 - 31 October 2019 and therefore falls into Year 3. Year 3 has therefore been added into column F:
Screen Shot 2017-12-23 at 17.44.10.jpg



I hope this makes sense.

Thank you in advance for any help,

Regards,

Margate