Spreadsheet: 741976d1627467559-return-a-value-for-a-date-between-multiple-date-ranges-book1
Sheet: Rates

Start Date | End Date | Daily Rate
2021-07-23 00:00:00 | 2021-07-29 00:00:00 | 257
2021-07-30 00:00:00 | 2021-08-05 00:00:00 | 241
2021-08-06 00:00:00 | 2021-08-12 00:00:00 | 253
2021-08-13 00:00:00 | 2021-08-19 00:00:00 | 283
2021-08-20 00:00:00 | 2021-09-02 00:00:00 | 291
2021-09-03 00:00:00 | 2021-09-09 00:00:00 | 265
2021-09-10 00:00:00 | 2021-09-16 00:00:00 | 291
2021-09-17 00:00:00 | 2021-09-23 00:00:00 | 288
2021-09-24 00:00:00 | 2021-09-30 00:00:00 | 298
2021-10-01 00:00:00 | 2021-10-14 00:00:00 | 294
2021-10-15 00:00:00 | 2021-10-21 00:00:00 | 271
2021-10-22 00:00:00 | 2021-10-24 00:00:00 | 320
2021-10-25 00:00:00 | 2021-10-28 00:00:00 | 294
2021-10-29 00:00:00 | 2021-11-04 00:00:00 | 271
2021-11-05 00:00:00 | 2021-11-18 00:00:00 | 265
2021-11-19 00:00:00 | 2021-11-21 00:00:00 | 444
2021-11-22 00:00:00 | 2021-11-25 00:00:00 | 444
2021-11-26 00:00:00 | 2021-12-02 00:00:00 | 319
2021-12-03 00:00:00 | 2021-12-16 00:00:00 | 297
2021-12-17 00:00:00 | 2021-12-21 00:00:00 | 265
2021-12-22 00:00:00 | 2021-12-22 00:00:00 | 671
2021-12-23 00:00:00 | 2021-12-26 00:00:00 | 671
2021-12-27 00:00:00 | 2022-01-04 00:00:00 | 671
2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 610
2022-01-07 00:00:00 | 2022-01-09 00:00:00 | 536
2022-01-10 00:00:00 | 2022-01-13 00:00:00 | 536
2022-01-14 00:00:00 | 2022-01-27 00:00:00 | 431
2022-01-28 00:00:00 | 2022-01-30 00:00:00 | 480
2022-01-31 00:00:00 | 2022-02-03 00:00:00 | 440
2022-02-04 00:00:00 | 2022-02-06 00:00:00 | 441
2022-02-07 00:00:00 | 2022-02-10 00:00:00 | 405
2022-02-11 00:00:00 | 2022-03-03 00:00:00 | 420
2022-03-04 00:00:00 | 2022-03-10 00:00:00 | 383
2022-03-11 00:00:00 | 2022-03-31 00:00:00 | 310
2022-04-01 00:00:00 | 2022-04-07 00:00:00 | 316
2022-04-08 00:00:00 | 2022-04-13 00:00:00 | 419
2022-04-14 00:00:00 | 2022-04-17 00:00:00 | 419
2022-04-18 00:00:00 | 2022-04-21 00:00:00 | 419
2022-04-22 00:00:00 | 2022-04-24 00:00:00 | 419
2022-04-25 00:00:00 | 2022-04-28 00:00:00 | 419
2022-04-29 00:00:00 | 2022-06-02 00:00:00 | 278
2022-06-03 00:00:00 | 2022-06-05 00:00:00 | 370
2022-06-06 00:00:00 | 2022-06-09 00:00:00 | 339
2022-06-10 00:00:00 | 2022-06-22 00:00:00 | 305
2022-06-23 00:00:00 | 2022-06-23 00:00:00 | 305
2022-06-24 00:00:00 | 2022-06-25 00:00:00 | 352
2022-06-26 00:00:00 | 2022-06-30 00:00:00 | 352
2022-07-01 00:00:00 | 2022-07-07 00:00:00 | 272
2022-07-08 00:00:00 | 2022-07-21 00:00:00 | 295
2022-07-22 00:00:00 | 2022-09-22 00:00:00 | 272
2022-09-23 00:00:00 | 2022-09-29 00:00:00 | 279
2022-09-30 00:00:00 | 2022-10-13 00:00:00 | 303
2022-10-14 00:00:00 | 2022-10-20 00:00:00 | 279
2022-10-21 00:00:00 | 2022-10-23 00:00:00 | 314
2022-10-24 00:00:00 | 2022-10-27 00:00:00 | 314
2022-10-28 00:00:00 | 2022-11-03 00:00:00 | 279
2022-11-04 00:00:00 | 2022-11-17 00:00:00 | 272
2022-11-18 00:00:00 | 2022-11-24 00:00:00 | 457
2022-11-25 00:00:00 | 2022-12-01 00:00:00 | 329
2022-12-02 00:00:00 | 2022-12-21 00:00:00 | 306
2022-12-22 00:00:00 | 2022-12-26 00:00:00 | 576
2022-12-27 00:00:00 | 2023-01-02 00:00:00 | 576
2023-01-03 00:00:00 | 2023-01-04 00:00:00 | 576
2023-01-05 00:00:00 | 2023-01-05 00:00:00 | 523
2023-01-06 00:00:00 | 2023-01-12 00:00:00 | 457
2023-01-13 00:00:00 | 2023-01-26 00:00:00 | 431
2023-01-27 00:00:00 | 2023-01-29 00:00:00 | 457
2023-01-30 00:00:00 | 2023-02-02 00:00:00 | 457
2023-02-03 00:00:00 | 2023-02-06 00:00:00 | 420
2023-02-07 00:00:00 | 2023-03-02 00:00:00 | 420
2023-03-03 00:00:00 | 2023-03-09 00:00:00 | 383
2023-03-10 00:00:00 | 2023-03-30 00:00:00 | 310
2023-03-31 00:00:00 | 2023-04-05 00:00:00 | 332
2023-04-06 00:00:00 | 2023-04-06 00:00:00 | 332
2023-04-07 00:00:00 | 2023-04-09 00:00:00 | 439
2023-04-10 00:00:00 | 2023-04-20 00:00:00 | 439
2023-04-21 00:00:00 | 2023-04-25 00:00:00 | 439
2023-04-26 00:00:00 | 2023-04-27 00:00:00 | 439
2023-04-28 00:00:00 | 2023-06-01 00:00:00 | 292
2023-06-02 00:00:00 | 2023-06-08 00:00:00 | 352
2023-06-09 00:00:00 | 2023-06-22 00:00:00 | 305
2023-06-23 00:00:00 | 2023-06-29 00:00:00 | 352
2023-06-30 00:00:00 | 2023-07-13 00:00:00 | 295
2021-06-28 00:00:00 | 2023-08-03 00:00:00 | 241
2023-07-14 00:00:00 | 2023-08-03 00:00:00 | 272