Spreadsheet: 741393d1627022495-earch-date-range-to-return-value-based-on-date-fortnight-is-found-booka-etaf-4-2-aligw
Sheet: Sheet2

Start | End | FNE |  |  | Pay date |  | Result
2016-12-19 00:00:00 | 2017-01-01 00:00:00 | 2017-01-01 00:00:00 |  |  | 18/12/2020 |  | 2020-12-27 00:00:00 |  | 2020-12-18 00:00:00
2017-01-02 00:00:00 | 2017-01-15 00:00:00 | 2017-01-15 00:00:00 |  |  | 01/02/2018 |  | 2018-02-11 00:00:00 |  | 2018-02-01 00:00:00
2017-01-16 00:00:00 | 2017-01-29 00:00:00 | 2017-01-29 00:00:00 |  |  | 01/10/2018 |  | 2018-12-07 00:00:00 |  | 2018-10-01 00:00:00
2017-01-30 00:00:00 | 2017-02-12 00:00:00 | 2017-02-12 00:00:00 |  |  | 02/11/2018 |  | ?
2017-02-13 00:00:00 | 2017-02-26 00:00:00 | 2017-02-26 00:00:00 |  |  | 03/11/2018 |  | ?
2017-02-27 00:00:00 | 2017-03-12 00:00:00 | 2017-03-12 00:00:00 |  |  | 04/02/2018 |  | ? |  |  |  | How do I get H column value to search table and return result based on FNE
2017-03-13 00:00:00 | 2017-03-26 00:00:00 | 2017-03-26 00:00:00 |  |  | 04/09/2018 |  | ?
2017-03-27 00:00:00 | 2017-04-09 00:00:00 | 2017-04-09 00:00:00 |  |  | 05/10/2018 |  | ? |  |  |  | This doesn't exist in FNE in your table …
2017-04-10 00:00:00 | 2017-04-23 00:00:00 | 2017-04-23 00:00:00 |  |  | 06/10/2018 |  | ?
2017-04-24 00:00:00 | 2017-05-07 00:00:00 | 2017-05-07 00:00:00 |  |  | 08/07/2018 |  | ?
2017-05-08 00:00:00 | 2017-05-21 00:00:00 | 2017-05-21 00:00:00 |  |  | 08/09/2018 |  | ?
2017-05-22 00:00:00 | 2017-06-04 00:00:00 | 2017-06-04 00:00:00 |  |  | 10/09/2018 |  | ?
2017-06-05 00:00:00 | 2017-06-18 00:00:00 | 2017-06-18 00:00:00 |  |  | 10/10/2018 |  | ?
2017-06-19 00:00:00 | 2017-07-02 00:00:00 | 2017-07-02 00:00:00 |  |  | 10/11/2018 |  | ?
2017-07-03 00:00:00 | 2017-07-16 00:00:00 | 2017-07-16 00:00:00 |  |  | 11/10/2018 |  | ?
2017-07-17 00:00:00 | 2017-07-30 00:00:00 | 2017-07-30 00:00:00 |  |  | 11/11/2018 |  | ?
2017-07-31 00:00:00 | 2017-08-13 00:00:00 | 2017-08-13 00:00:00 |  |  | 11/12/2018 |  | ?
2017-08-14 00:00:00 | 2017-08-27 00:00:00 | 2017-08-27 00:00:00 |  |  | 12/07/2018 |  | ?
2017-08-28 00:00:00 | 2017-09-10 00:00:00 | 2017-09-10 00:00:00 |  |  | 12/12/2018 |  | ?
2017-09-11 00:00:00 | 2017-09-24 00:00:00 | 2017-09-24 00:00:00 |  |  | 14/07/2018 |  | ?
2017-09-25 00:00:00 | 2017-10-08 00:00:00 | 2017-10-08 00:00:00 |  |  | 14/08/2018 |  | ?
2017-10-09 00:00:00 | 2017-10-22 00:00:00 | 2017-10-22 00:00:00 |  |  | 14/11/2018 |  | ?
2017-10-23 00:00:00 | 2017-11-05 00:00:00 | 2017-11-05 00:00:00 |  |  | 15/10/2018 |  | ?
2017-11-06 00:00:00 | 2017-11-19 00:00:00 | 2017-11-19 00:00:00 |  |  | 17/08/2018 |  | ?
2017-11-20 00:00:00 | 2017-12-03 00:00:00 | 2017-12-03 00:00:00
2017-12-04 00:00:00 | 2017-12-17 00:00:00 | 2017-12-17 00:00:00
2017-12-18 00:00:00 | 2017-12-31 00:00:00 | 2017-12-31 00:00:00
2018-01-01 00:00:00 | 2018-01-14 00:00:00 | 2018-01-14 00:00:00
2018-01-15 00:00:00 | 2018-01-28 00:00:00 | 2018-01-28 00:00:00
2018-01-29 00:00:00 | 2018-02-11 00:00:00 | 2018-02-11 00:00:00
2018-02-12 00:00:00 | 2018-02-25 00:00:00 | 2018-02-25 00:00:00
2018-02-26 00:00:00 | 2018-03-11 00:00:00 | 2018-03-11 00:00:00
2018-03-12 00:00:00 | 2018-03-25 00:00:00 | 2018-03-25 00:00:00
2018-03-26 00:00:00 | 2018-04-08 00:00:00 | 2018-04-08 00:00:00
2018-04-09 00:00:00 | 2018-04-22 00:00:00 | 2018-04-22 00:00:00
2018-04-23 00:00:00 | 2018-05-06 00:00:00 | 2018-05-06 00:00:00
2018-05-07 00:00:00 | 2018-05-20 00:00:00 | 2018-05-20 00:00:00
2018-05-21 00:00:00 | 2018-06-03 00:00:00 | 2018-06-03 00:00:00
2018-06-04 00:00:00 | 2018-06-17 00:00:00 | 2018-06-17 00:00:00
2018-06-18 00:00:00 | 2018-07-01 00:00:00 | 2018-07-01 00:00:00
2018-07-02 00:00:00 | 2018-07-15 00:00:00 | 2018-07-15 00:00:00
2018-07-16 00:00:00 | 2018-07-29 00:00:00 | 2018-07-29 00:00:00
2018-07-30 00:00:00 | 2018-08-12 00:00:00 | 2018-08-12 00:00:00
2018-08-13 00:00:00 | 2018-08-26 00:00:00 | 2018-08-26 00:00:00
2018-08-27 00:00:00 | 2018-09-09 00:00:00 | 2018-09-09 00:00:00
2018-09-10 00:00:00 | 2018-09-23 00:00:00 | 2018-09-23 00:00:00
2018-09-24 00:00:00 | 2018-10-07 00:00:00 | 2018-10-07 00:00:00
2018-10-08 00:00:00 | 2018-10-21 00:00:00 | 2018-10-21 00:00:00
2018-10-22 00:00:00 | 2018-11-04 00:00:00 | 2018-11-04 00:00:00
2018-11-05 00:00:00 | 2018-11-18 00:00:00 | 2018-11-18 00:00:00
2018-11-19 00:00:00 | 2018-12-02 00:00:00 | 2018-12-02 00:00:00
2018-12-03 00:00:00 | 2018-12-16 00:00:00 | 2018-12-16 00:00:00
2018-12-17 00:00:00 | 2018-12-30 00:00:00 | 2018-12-30 00:00:00
2018-12-31 00:00:00 | 2019-01-13 00:00:00 | 2019-01-13 00:00:00
2019-01-14 00:00:00 | 2019-01-27 00:00:00 | 2019-01-27 00:00:00
2019-01-28 00:00:00 | 2019-02-10 00:00:00 | 2019-02-10 00:00:00
2019-02-11 00:00:00 | 2019-02-24 00:00:00 | 2019-02-24 00:00:00
2019-02-25 00:00:00 | 2019-03-10 00:00:00 | 2019-03-10 00:00:00
2019-03-11 00:00:00 | 2019-03-24 00:00:00 | 2019-03-24 00:00:00
2019-03-25 00:00:00 | 2019-04-07 00:00:00 | 2019-04-07 00:00:00
2019-04-08 00:00:00 | 2019-04-21 00:00:00 | 2019-04-21 00:00:00
2019-04-22 00:00:00 | 2019-05-05 00:00:00 | 2019-05-05 00:00:00
2019-05-06 00:00:00 | 2019-05-19 00:00:00 | 2019-05-19 00:00:00
2019-05-20 00:00:00 | 2019-06-02 00:00:00 | 2019-06-02 00:00:00
2019-06-03 00:00:00 | 2019-06-16 00:00:00 | 2019-06-16 00:00:00
2019-06-17 00:00:00 | 2019-06-30 00:00:00 | 2019-06-30 00:00:00
2019-07-01 00:00:00 | 2019-07-14 00:00:00 | 2019-07-14 00:00:00
2019-07-15 00:00:00 | 2019-07-28 00:00:00 | 2019-07-28 00:00:00
2019-07-29 00:00:00 | 2019-08-11 00:00:00 | 2019-08-11 00:00:00
2019-08-12 00:00:00 | 2019-08-25 00:00:00 | 2019-08-25 00:00:00
2019-08-26 00:00:00 | 2019-09-08 00:00:00 | 2019-09-08 00:00:00
2019-09-09 00:00:00 | 2019-09-22 00:00:00 | 2019-09-22 00:00:00
2019-09-23 00:00:00 | 2019-10-06 00:00:00 | 2019-10-06 00:00:00
2019-10-07 00:00:00 | 2019-10-20 00:00:00 | 2019-10-20 00:00:00
2019-10-21 00:00:00 | 2019-11-03 00:00:00 | 2019-11-03 00:00:00
2019-11-04 00:00:00 | 2019-11-17 00:00:00 | 2019-11-17 00:00:00
2019-11-18 00:00:00 | 2019-12-01 00:00:00 | 2019-12-01 00:00:00
2019-12-02 00:00:00 | 2019-12-15 00:00:00 | 2019-12-15 00:00:00
2019-12-16 00:00:00 | 2019-12-29 00:00:00 | 2019-12-29 00:00:00
2019-12-30 00:00:00 | 2020-01-12 00:00:00 | 2020-01-12 00:00:00
2020-01-13 00:00:00 | 2020-01-26 00:00:00 | 2020-01-26 00:00:00
2020-01-27 00:00:00 | 2020-02-09 00:00:00 | 2020-02-09 00:00:00
2020-02-10 00:00:00 | 2020-02-23 00:00:00 | 2020-02-23 00:00:00
2020-02-24 00:00:00 | 2020-03-08 00:00:00 | 2020-03-08 00:00:00
2020-03-09 00:00:00 | 2020-03-22 00:00:00 | 2020-03-22 00:00:00
2020-03-23 00:00:00 | 2020-04-05 00:00:00 | 2020-04-05 00:00:00
2020-04-06 00:00:00 | 2020-04-19 00:00:00 | 2020-04-19 00:00:00
2020-04-20 00:00:00 | 2020-05-03 00:00:00 | 2020-05-03 00:00:00
2020-05-04 00:00:00 | 2020-05-17 00:00:00 | 2020-05-17 00:00:00
2020-05-18 00:00:00 | 2020-05-31 00:00:00 | 2020-05-31 00:00:00
2020-06-01 00:00:00 | 2020-06-14 00:00:00 | 2020-06-14 00:00:00
2020-06-15 00:00:00 | 2020-06-28 00:00:00 | 2020-06-28 00:00:00
2020-06-29 00:00:00 | 2020-07-12 00:00:00 | 2020-07-12 00:00:00
2020-07-13 00:00:00 | 2020-07-26 00:00:00 | 2020-07-26 00:00:00
2020-07-27 00:00:00 | 2020-08-09 00:00:00 | 2020-08-09 00:00:00
2020-08-10 00:00:00 | 2020-08-23 00:00:00 | 2020-08-23 00:00:00
2020-08-24 00:00:00 | 2020-09-06 00:00:00 | 2020-09-06 00:00:00
2020-09-07 00:00:00 | 2020-09-20 00:00:00 | 2020-09-20 00:00:00
2020-09-21 00:00:00 | 2020-10-04 00:00:00 | 2020-10-04 00:00:00
2020-10-05 00:00:00 | 2020-10-18 00:00:00 | 2020-10-18 00:00:00
2020-10-19 00:00:00 | 2020-11-01 00:00:00 | 2020-11-01 00:00:00
2020-11-02 00:00:00 | 2020-11-15 00:00:00 | 2020-11-15 00:00:00
2020-11-16 00:00:00 | 2020-11-29 00:00:00 | 2020-11-29 00:00:00
2020-11-30 00:00:00 | 2020-12-13 00:00:00 | 2020-12-13 00:00:00
2020-12-14 00:00:00 | 2020-12-27 00:00:00 | 2020-12-27 00:00:00
2020-12-28 00:00:00 | 2021-01-10 00:00:00 | 2021-01-10 00:00:00
2021-01-11 00:00:00 | 2021-01-24 00:00:00 | 2021-01-24 00:00:00
2021-01-25 00:00:00 | 2021-02-07 00:00:00 | 2021-02-07 00:00:00
2021-02-08 00:00:00 | 2021-02-21 00:00:00 | 2021-02-21 00:00:00
2021-02-22 00:00:00 | 2021-03-07 00:00:00 | 2021-03-07 00:00:00
2021-03-08 00:00:00 | 2021-03-21 00:00:00 | 2021-03-21 00:00:00
2021-03-22 00:00:00 | 2021-04-04 00:00:00 | 2021-04-04 00:00:00
2021-04-05 00:00:00 | 2021-04-18 00:00:00 | 2021-04-18 00:00:00
2021-04-19 00:00:00 | 2021-05-02 00:00:00 | 2021-05-02 00:00:00
2021-05-03 00:00:00 | 2021-05-16 00:00:00 | 2021-05-16 00:00:00
2021-05-17 00:00:00 | 2021-05-30 00:00:00 | 2021-05-30 00:00:00
2021-05-31 00:00:00 | 2021-06-13 00:00:00 | 2021-06-13 00:00:00
2021-06-14 00:00:00 | 2021-06-27 00:00:00 | 2021-06-27 00:00:00
2021-06-28 00:00:00 | 2021-07-11 00:00:00 | 2021-07-11 00:00:00
2021-07-12 00:00:00 | 2021-07-25 00:00:00 | 2021-07-25 00:00:00
2021-07-26 00:00:00 | 2021-08-08 00:00:00 | 2021-08-08 00:00:00
2021-08-09 00:00:00 | 2021-08-22 00:00:00 | 2021-08-22 00:00:00
2021-08-23 00:00:00 | 2021-09-05 00:00:00 | 2021-09-05 00:00:00
2021-09-06 00:00:00 | 2021-09-19 00:00:00 | 2021-09-19 00:00:00
2021-09-20 00:00:00 | 2021-10-03 00:00:00 | 2021-10-03 00:00:00
2021-10-04 00:00:00 | 2021-10-17 00:00:00 | 2021-10-17 00:00:00
2021-10-18 00:00:00 | 2021-10-31 00:00:00 | 2021-10-31 00:00:00
2021-11-01 00:00:00 | 2021-11-14 00:00:00 | 2021-11-14 00:00:00
2021-11-15 00:00:00 | 2021-11-28 00:00:00 | 2021-11-28 00:00:00
2021-11-29 00:00:00 | 2021-12-12 00:00:00 | 2021-12-12 00:00:00
2021-12-13 00:00:00 | 2021-12-26 00:00:00 | 2021-12-26 00:00:00