Spreadsheet: 838673d1691246026-the-last-value-between-date-to-date-lats-value-not-equal-null-between-2-date
Sheet: Sheet1

2023-05-01 00:00:00 | 2023-05-02 00:00:00 | 2023-05-03 00:00:00 | 2023-05-04 00:00:00 | 2023-05-05 00:00:00 | 2023-05-06 00:00:00 | 2023-05-07 00:00:00 | 2023-05-08 00:00:00 | 2023-05-09 00:00:00 | 2023-05-10 00:00:00 | 2023-05-11 00:00:00 | 2023-05-12 00:00:00 | 2023-05-13 00:00:00 | 2023-05-14 00:00:00 | 2023-05-15 00:00:00 | 2023-05-16 00:00:00 | 2023-05-17 00:00:00 | 2023-05-18 00:00:00 | 2023-05-19 00:00:00 | 2023-05-20 00:00:00 | 2023-05-21 00:00:00 | 2023-05-22 00:00:00 | 2023-05-23 00:00:00 | 2023-05-24 00:00:00 | 2023-05-25 00:00:00 | 2023-05-26 00:00:00 | 2023-05-27 00:00:00 | 2023-05-28 00:00:00 | 2023-05-29 00:00:00 | 2023-05-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-01 00:00:00 | 2023-06-02 00:00:00 | 2023-06-03 00:00:00 | 2023-06-04 00:00:00 | 2023-06-05 00:00:00 | 2023-06-06 00:00:00 | 2023-06-07 00:00:00 | 2023-06-08 00:00:00 | 2023-06-09 00:00:00 | 2023-06-10 00:00:00 | 2023-06-11 00:00:00 | 2023-06-12 00:00:00 | 2023-06-13 00:00:00 | 2023-06-14 00:00:00 | 2023-06-15 00:00:00 | 2023-06-16 00:00:00 | 2023-06-17 00:00:00 | 2023-06-18 00:00:00 | 2023-06-19 00:00:00 | 2023-06-20 00:00:00 | 2023-06-21 00:00:00 | 2023-06-22 00:00:00 | 2023-06-23 00:00:00 | 2023-06-24 00:00:00 | 2023-06-25 00:00:00 | 2023-06-26 00:00:00 | 2023-06-27 00:00:00 | 2023-06-28 00:00:00 | 2023-06-29 00:00:00 | 2023-06-30 00:00:00 | 2023-07-01 00:00:00 | 2023-07-02 00:00:00 | 2023-07-03 00:00:00 | 2023-07-04 00:00:00 | 2023-07-05 00:00:00 | 2023-07-06 00:00:00 | 2023-07-07 00:00:00 | 2023-07-08 00:00:00 | 2023-07-09 00:00:00 | 2023-07-10 00:00:00 | 2023-07-11 00:00:00 | 2023-07-12 00:00:00 | 2023-07-13 00:00:00 | 2023-07-14 00:00:00 | 2023-07-15 00:00:00 | 2023-07-16 00:00:00 | 2023-07-17 00:00:00 | 2023-07-18 00:00:00 | 2023-07-19 00:00:00 | 2023-07-20 00:00:00 | 2023-07-21 00:00:00 | 2023-07-22 00:00:00 | 2023-07-23 00:00:00 | 2023-07-24 00:00:00 | 2023-07-25 00:00:00 | 2023-07-26 00:00:00 | 2023-07-27 00:00:00 | 2023-07-28 00:00:00 | 2023-07-29 00:00:00 | 2023-07-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-01 00:00:00 | 2023-08-02 00:00:00 | 2023-08-03 00:00:00 | 2023-08-04 00:00:00 | 2023-08-05 00:00:00 | 2023-08-06 00:00:00 | 2023-08-07 00:00:00 | 2023-08-08 00:00:00 | 2023-08-09 00:00:00 | 2023-08-10 00:00:00
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 8 | 4 | 4 | 4 | 4 | 4 | 34 | 44
START DATE | END DATE | LAST VALUE
2023-05-01 00:00:00 |  |  | In Cell [C6] I need to write formula to get the last value between 01/05/2023 till 01/06/2023 not <> Null.
 |  |  | In Cell [C7] I need to write formula to get the last value between 02/06/2023 till 01/07/2023 not <> Null.
 |  |  | In Cell [C8] I need to write formula to get the last value between 02/07/2023 till 01/08/2023 not <> Null.
 |  |  | In Cell [C9] I need to write formula to get the last value between 02/08/2023 till 10/08/2023 not <> Null.