Spreadsheet: 783882d1655271565-want-to-show-value-of-g12-in-cell-j2-with-reference-value-of-i2-book2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Expected Results
 |  |  | 2022-06-20 00:00:00 |  | Monday | 100 |  | 2022-06-30 00:00:00
 |  |  | 2022-06-21 00:00:00 | 5 | Tuesday | 105 |  | 2022-07-31 00:00:00
 |  |  | 2022-06-22 00:00:00 | 5.25 | Wednesday | 110.25 |  | 2022-08-31 00:00:00
 |  |  | 2022-06-23 00:00:00 | 5.512500000000003 | Thursday | 115.7625 |  | 2022-09-30 00:00:00
 |  |  | 2022-06-24 00:00:00 | 5.788124999999994 | Friday | 121.550625 |  | 2022-10-31 00:00:00
 |  |  | 2022-06-25 00:00:00 | 0 | Saturday | 121.550625 |  | 2022-11-30 00:00:00
 |  |  | 2022-06-26 00:00:00 | 0 | Sunday | 121.550625 |  | 2022-12-31 00:00:00
 |  |  | 2022-06-27 00:00:00 | 6.077531249999993 | Monday | 127.62815625 |  | 2023-01-31 00:00:00
 |  |  | 2022-06-28 00:00:00 | 6.381407812499987 | Tuesday | 134.0095640625 |  | 2023-02-28 00:00:00
 |  |  | 2022-06-29 00:00:00 | 6.700478203124987 | Wednesday | 140.710042265625 |  | 2023-03-31 00:00:00
 |  |  | 2022-06-30 00:00:00 | 7.03550211328124 | Thursday | 147.7455443789062 |  | 2023-04-30 00:00:00
 |  |  | 2022-07-01 00:00:00 | 7.387277218945314 | Friday | 155.1328215978515 |  | 2023-05-31 00:00:00
 |  |  | 2022-07-02 00:00:00 | 0 | Saturday | 155.1328215978515 |  | 2023-06-30 00:00:00
 |  |  | 2022-07-03 00:00:00 | 0 | Sunday | 155.1328215978515 |  | 2023-07-31 00:00:00
 |  |  | 2022-07-04 00:00:00 | 7.756641079892574 | Monday | 162.8894626777441 |  | 2023-08-31 00:00:00
 |  |  | 2022-07-05 00:00:00 | 8.144473133887203 | Tuesday | 171.0339358116313 |  | 2023-09-30 00:00:00
 |  |  | 2022-07-06 00:00:00 | 8.551696790581559 | Wednesday | 179.5856326022129 |  | 2023-10-31 00:00:00
 |  |  | 2022-07-07 00:00:00 | 8.979281630110648 | Thursday | 188.5649142323235 |  | 2023-11-30 00:00:00
 |  |  | 2022-07-08 00:00:00 | 9.42824571161617 | Friday | 197.9931599439397 |  | 2023-12-31 00:00:00
 |  |  | 2022-07-09 00:00:00 | 0 | Saturday | 197.9931599439397
 |  |  | 2022-07-10 00:00:00 | 0 | Sunday | 197.9931599439397
 |  |  | 2022-07-11 00:00:00 | 9.899657997196982 | Monday | 207.8928179411367
 |  |  | 2022-07-12 00:00:00 | 10.39464089705683 | Tuesday | 218.2874588381935
 |  |  | 2022-07-13 00:00:00 | 10.91437294190968 | Wednesday | 229.2018317801032
 |  |  | 2022-07-14 00:00:00 | 11.46009158900515 | Thursday | 240.6619233691083
 |  |  | 2022-07-15 00:00:00 | 12.03309616845542 | Friday | 252.6950195375637
 |  |  | 2022-07-16 00:00:00 | 0 | Saturday | 252.6950195375637
 |  |  | 2022-07-17 00:00:00 | 0 | Sunday | 252.6950195375637
 |  |  | 2022-07-18 00:00:00 | 12.63475097687819 | Monday | 265.3297705144419
 |  |  | 2022-07-19 00:00:00 | 13.26648852572208 | Tuesday | 278.596259040164
 |  |  | 2022-07-20 00:00:00 | 13.92981295200821 | Wednesday | 292.5260719921722
 |  |  | 2022-07-21 00:00:00 | 14.6263035996086 | Thursday | 307.1523755917808
 |  |  | 2022-07-22 00:00:00 | 15.35761877958902 | Friday | 322.5099943713698
 |  |  | 2022-07-23 00:00:00 | 0 | Saturday | 322.5099943713698
 |  |  | 2022-07-24 00:00:00 | 0 | Sunday | 322.5099943713698
 |  |  | 2022-07-25 00:00:00 | 16.12549971856851 | Monday | 338.6354940899383
 |  |  | 2022-07-26 00:00:00 | 16.93177470449689 | Tuesday | 355.5672687944352
 |  |  | 2022-07-27 00:00:00 | 17.77836343972177 | Wednesday | 373.345632234157
 |  |  | 2022-07-28 00:00:00 | 18.66728161170784 | Thursday | 392.0129138458648
 |  |  | 2022-07-29 00:00:00 | 19.60064569229326 | Friday | 411.6135595381581
 |  |  | 2022-07-30 00:00:00 | 0 | Saturday | 411.6135595381581
 |  |  | 2022-07-31 00:00:00 | 0 | Sunday | 411.6135595381581
 |  |  | 2022-08-01 00:00:00 | 20.58067797690791 | Monday | 432.194237515066
 |  |  | 2022-08-02 00:00:00 | 21.60971187575331 | Tuesday | 453.8039493908193
 |  |  | 2022-08-03 00:00:00 | 22.69019746954098 | Wednesday | 476.4941468603603
 |  |  | 2022-08-04 00:00:00 | 23.82470734301802 | Thursday | 500.3188542033783
 |  |  | 2022-08-05 00:00:00 | 25.01594271016887 | Friday | 525.3347969135472
 |  |  | 2022-08-06 00:00:00 | 0 | Saturday | 525.3347969135472
 |  |  | 2022-08-07 00:00:00 | 0 | Sunday | 525.3347969135472
 |  |  | 2022-08-08 00:00:00 | 26.26673984567731 | Monday | 551.6015367592245
 |  |  | 2022-08-09 00:00:00 | 27.5800768379612 | Tuesday | 579.1816135971857
 |  |  | 2022-08-10 00:00:00 | 28.95908067985931 | Wednesday | 608.140694277045
 |  |  | 2022-08-11 00:00:00 | 30.40703471385223 | Thursday | 638.5477289908972
 |  |  | 2022-08-12 00:00:00 | 31.92738644954488 | Friday | 670.4751154404421
 |  |  | 2022-08-13 00:00:00 | 0 | Saturday | 670.4751154404421
 |  |  | 2022-08-14 00:00:00 | 0 | Sunday | 670.4751154404421
 |  |  | 2022-08-15 00:00:00 | 33.52375577202213 | Monday | 703.9988712124642
 |  |  | 2022-08-16 00:00:00 | 35.19994356062318 | Tuesday | 739.1988147730874
 |  |  | 2022-08-17 00:00:00 | 36.95994073865438 | Wednesday | 776.1587555117418
 |  |  | 2022-08-18 00:00:00 | 38.80793777558711 | Thursday | 814.9666932873289
 |  |  | 2022-08-19 00:00:00 | 40.74833466436644 | Friday | 855.7150279516953
 |  |  | 2022-08-20 00:00:00 | 0 | Saturday | 855.7150279516953
 |  |  | 2022-08-21 00:00:00 | 0 | Sunday | 855.7150279516953
 |  |  | 2022-08-22 00:00:00 | 42.7857513975847 | Monday | 898.50077934928
 |  |  | 2022-08-23 00:00:00 | 44.92503896746405 | Tuesday | 943.4258183167441
 |  |  | 2022-08-24 00:00:00 | 47.17129091583718 | Wednesday | 990.5971092325813
 |  |  | 2022-08-25 00:00:00 | 49.52985546162904 | Thursday | 1040.12696469421
 |  |  | 2022-08-26 00:00:00 | 52.00634823471046 | Friday | 1092.133312928921
 |  |  | 2022-08-27 00:00:00 | 0 | Saturday | 1092.133312928921
 |  |  | 2022-08-28 00:00:00 | 0 | Sunday | 1092.133312928921
 |  |  | 2022-08-29 00:00:00 | 54.60666564644612 | Monday | 1146.739978575367
 |  |  | 2022-08-30 00:00:00 | 57.33699892876825 | Tuesday | 1204.076977504135
 |  |  | 2022-08-31 00:00:00 | 60.20384887520686 | Wednesday | 1264.280826379342
 |  |  | 2022-09-01 00:00:00 | 63.21404131896702 | Thursday | 1327.494867698309
 |  |  | 2022-09-02 00:00:00 | 66.37474338491552 | Friday | 1393.869611083225
 |  |  | 2022-09-03 00:00:00 | 0 | Saturday | 1393.869611083225
 |  |  | 2022-09-04 00:00:00 | 0 | Sunday | 1393.869611083225
 |  |  | 2022-09-05 00:00:00 | 69.69348055416117 | Monday | 1463.563091637386
 |  |  | 2022-09-06 00:00:00 | 73.1781545818692 | Tuesday | 1536.741246219255
 |  |  | 2022-09-07 00:00:00 | 76.83706231096266 | Wednesday | 1613.578308530218
 |  |  | 2022-09-08 00:00:00 | 80.67891542651091 | Thursday | 1694.257223956728
 |  |  | 2022-09-09 00:00:00 | 84.71286119783645 | Friday | 1778.970085154565
 |  |  | 2022-09-10 00:00:00 | 0 | Saturday | 1778.970085154565
 |  |  | 2022-09-11 00:00:00 | 0 | Sunday | 1778.970085154565
 |  |  | 2022-09-12 00:00:00 | 88.94850425772825 | Monday | 1867.918589412293
 |  |  | 2022-09-13 00:00:00 | 93.39592947061465 | Tuesday | 1961.314518882908
 |  |  | 2022-09-14 00:00:00 | 98.06572594414524 | Wednesday | 2059.380244827053
 |  |  | 2022-09-15 00:00:00 | 102.9690122413526 | Thursday | 2162.349257068406
 |  |  | 2022-09-16 00:00:00 | 108.1174628534204 | Friday | 2270.466719921826
 |  |  | 2022-09-17 00:00:00 | 0 | Saturday | 2270.466719921826
 |  |  | 2022-09-18 00:00:00 | 0 | Sunday | 2270.466719921826
 |  |  | 2022-09-19 00:00:00 | 113.5233359960912 | Monday | 2383.990055917917
 |  |  | 2022-09-20 00:00:00 | 119.199502795896 | Tuesday | 2503.189558713813
 |  |  | 2022-09-21 00:00:00 | 125.1594779356906 | Wednesday | 2628.349036649504
 |  |  | 2022-09-22 00:00:00 | 131.4174518324753 | Thursday | 2759.766488481979
 |  |  | 2022-09-23 00:00:00 | 137.9883244240991 | Friday | 2897.754812906078
 |  |  | 2022-09-24 00:00:00 | 0 | Saturday | 2897.754812906078
 |  |  | 2022-09-25 00:00:00 | 0 | Sunday | 2897.754812906078
 |  |  | 2022-09-26 00:00:00 | 144.8877406453039 | Monday | 3042.642553551382
 |  |  | 2022-09-27 00:00:00 | 152.1321276775693 | Tuesday | 3194.774681228952