Spreadsheet: 872612d1718979441-i-need-to-use-an-index-to-add-forecast-data-into-the-correct-periods-based-on-go-live-mth-1-upcoming-venue-switch-data
Sheet: Sheet1

DATA | Revenue Projections | Opening Date | -6 | -5 | -4 | -3 | -2 | -1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
 | Edgware | 2024-09-01 00:00:00 |  |  |  |  |  |  |  | 48409.4 | 51163.28 | 53917.16 | 56671.04 | 59424.92 | 62178.8 | 64950 | 64950 | 66915.82 | 68881.64 | 70847.46 | 72813.28 | 74779.1 | 76744.92 | 78710.74 | 80676.56 | 82642.38 | 84608.2 | 86600
 | Wembley | 2024-12-01 00:00:00 |  |  |  |  |  |  |  | 55099.25 | 57459.1 | 59818.95 | 62178.8 | 64538.65 | 66898.5 | 69280 | 69280 | 71639.85 | 73999.7 | 76359.55 | 78719.4 | 81079.25 | 83439.1 | 85798.95 | 88158.8 | 90518.65000000001 | 92878.5 | 95260
 | [NAME] | 2024-11-01 00:00:00 |  |  |  |  |  |  |  | 63759.25 | 66119.1 | 68478.95 | 70838.8 | 73198.65 | 75558.5 | 77940 | 77940 | 80299.85 | 82659.7 | 85019.55 | 87379.4 | 89739.25 | 92099.1 | 94458.95 | 96818.8 | 99178.65000000001 | 101538.5 | 103920
 | Wood Green 144 | 2024-09-01 00:00:00 |  |  |  |  |  |  |  | 55099.25 | 57459.1 | 59818.95 | 62178.8 | 64538.65 | 66898.5 | 69280 | 69280 | 71639.85 | 73999.7 | 76359.55 | 78719.4 | 81079.25 | 83439.1 | 85798.95 | 88158.8 | 90518.65000000001 | 92878.5 | 95260
 | Edmonton | 2024-08-01 00:00:00 |  |  |  |  |  |  |  | 48409.4 | 51163.28 | 53917.16 | 56671.04 | 59424.92 | 62178.8 | 64950 | 64950 | 66915.82 | 68881.64 | 70847.46 | 72813.28 | 74779.1 | 76744.92 | 78710.74 | 80676.56 | 82642.38 | 84608.2 | 86600
 | Lewisham | 2024-08-01 00:00:00 |  |  |  |  |  |  |  | 55099.25 | 57459.1 | 59818.95 | 62178.8 | 64538.65 | 66898.5 | 69280 | 69280 | 70851.79000000001 | 72423.58 | 73995.37 | 75567.16 | 77138.95 | 78710.74 | 80282.53 | 81854.32 | 83426.11 | 84997.9 | 86600
 | Cricklewood | 2024-11-01 00:00:00 |  |  |  |  |  |  |  | 55099.25 | 57459.1 | 59818.95 | 62178.8 | 64538.65 | 66898.5 | 69280 | 69280 | 71639.85 | 73999.7 | 76359.55 | 78719.4 | 81079.25 | 83439.1 | 85798.95 | 88158.8 | 90518.65000000001 | 92878.5 | 95260
 | [NAME] | 2024-12-01 00:00:00 |  |  |  |  |  |  |  | 63759.25 | 66119.1 | 68478.95 | 70838.8 | 73198.65 | 75558.5 | 77940 | 77940 | 80299.85 | 82659.7 | 85019.55 | 87379.4 | 89739.25 | 92099.1 | 94458.95 | 96818.8 | 99178.65000000001 | 101538.5 | 103920
 | Cost of Sales |  | -6 | -5 | -4 | -3 | -2 | -1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
 | Edgware |  |  |  |  |  | 2741.67 | 16619.17 | 21840.67 | 49396.1146 | 45791.12560000001 | 46438.2874 | 47086.0554 | 48337.470822 | 48957.05052200001 | 49580.094222 | 56348.897922 | 50110.86562200001 | 50572.833322 | 51034.80102200001 | 51496.768722 | 51958.736422 | 86349.41502199999 | 49921.384822 | 50314.548822
 | Wembley |  |  |  |  | 10360 | 26696.22335 | 32928.8181 | 51865.70825 | 59002.2805 | 52974.92415 | 53576.6859 | 54178.44765 | 54780.2094 | 55387.4919 | 55387.4919 | 62689.25365 | 56591.0154 | 57192.77715 | 64494.53889999999 | 58396.30065
 | [NAME] |  | 4135 | 9335 | 7807.5 | 11371.25 | 21873.4374 | 25255.01115 | 49739.65590000001 | 50294.22065 | 58166.829772 | 52021.39452200001 | 52575.959272 | 53130.52402200001 | 53690.176522 | 53690.176522 | 54244.74127200001 | 61499.306022 | 55353.870772 | 55908.43552200001 | 56463.000272 | 57017.56502200001
 | Wood Green 144 |  |  |  |  | 7835 | 27402.1898 | 24802.1898 | 41631.7448 | 50503.8893 | 44393.8518 | 44983.81430000001 | 46051.00840000001 | 46640.97090000001 | 47235.6964 | 49107.1414 | 47826.3084 | 48416.2709 | 49006.2334 | 49596.1959 | 50186.1584 | 57476.12090000001 | 51366.0834 | 52026.8414
 | Edmonton |  |  |  |  |  |  | 21520.7684 | 25482.8096 | 44226.8918 | 47021.844 | 48372.986 | 49006.3784 | 56339.7708 | 50983.20198800001 | 51202.828388 | 51202.828388 | 53454.96698800001 | 52107.105588 | 52559.244188 | 53011.382788 | 53463.521388 | 53915.65998800001 | 61067.798588 | 54819.937188 | 55272.075788
 | Lewisham |  |  |  | 200 | 200 | 14650 | 23852.33 | 49617.7194 | 50208.24920000001 | 50980.21920000001 | 51452.18920000001 | 58624.15920000001 | 53163.116488 | 53221.666888 | 53221.666888 | 55336.024888 | 53850.382888 | 54164.740888 | 54479.098888 | 54793.456888 | 55107.814888 | 62122.172888 | 55736.530888 | 56050.888888
 | Cricklewood |  |  |  |  |  |  | 8500 | 33613.5 | 51132.3345 | 51976.10000000001 | 52518.86550000001 | 53061.63100000001 | 53604.39650000001 | 55947.162 | 54694.90700000001 | 54694.90700000001 | 55237.67250000001 | 55780.43800000001 | 56323.2035 | 63565.969 | 57408.7345 | 57951.50000000001
 | [NAME] |  |  |  |  | 17850 | 26950 | 54882.13450000001 | 55424.9 | 55967.66550000001 | 56510.431 | 58853.19650000001 | 57595.962 | 58143.70700000001 | 58143.70700000001 | 58686.4725 | 59229.23800000001 | 66472.0035 | 60314.76900000001 | 60857.53450000001
 | Overheads |  | -6 | -5 | -4 | -3 | -2 | -1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
 | Edgware |  |  |  |  |  | 43241 | 4439 | 15404 | 8146 | 5431 | 5056 | 5616 | 5056 | 5856 | 5341 | 5056 | 5396 | 5386 | 5056 | 5716 | 5056 | 5556 | 5526 | 5616
 | Wembley |  |  |  |  | 1859 | 2904 | 3646 | 5441 | 5246 | 15626 | 47616 | 5056 | 5856 | 5341 | 5056 | 5396 | 5386 | 5056 | 5716 | 5056 | 5556 | 5526 | 5616
 | [NAME] |  | 4309 | 13254 | 6046 | 5341 | 5071 | 46981 | 5616 | 5056 | 5856 | 5341 | 5056 | 5396 | 5386 | 5056 | 5716 | 5056 | 5556 | 5526 | 5616
 | Wood Green 144 |  |  |  |  | 5081 | 5404 | 56046 | 5341 | 5146 | 5526 | 5616 | 5056 | 5856 | 5341 | 5056 | 5396 | 5386 | 5056 | 5716 | 5056 | 5556 | 5526 | 5616
 | Edmonton |  |  |  |  |  |  | 7683 | 6833 | 7404 | 6046 | 5146 | 5526 | 5616 | 5056 | 5856 | 5341 | 5056 | 5396 | 5386 | 5056 | 5716 | 5056 | 5556 | 5526 | 5616
 | Lewisham |  |  |  |  | 83 | 83 | 3640 | 56533 | 7404 | 6046 | 5146 | 5526 | 5616 | 5056 | 5856 | 5341 | 5056 | 5396 | 5386 | 5056 | 5716 | 5056 | 5556 | 5526 | 5616
 | Cricklewood |  |  |  |  |  |  |  | 45771 | 13771 | 5771 | 5256 | 4971 | 5311 | 5301 | 4971 | 5631 | 4971 | 5471 | 5441 | 5531 | 5301 | 5601
 | [NAME] |  |  |  |  |  |  |  |  | 47566 | 5566 | 5771 | 5256 | 4971 | 5311 | 5301 | 4971 | 5631 | 4971 | 5471 | 5441 | 5531 | 5441 | 5531
Source Data
 | Total Cashflow | Opening Date | -6 | -5 | -4 | -3 | -2 | -1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
Contains the cashflows for upcoming venues based around opening date (Period 1) | Edgware | 2024-09-01 00:00:00
 | Wembley | 2024-12-01 00:00:00
 | [NAME] | 2024-11-01 00:00:00
 | Wood Green 144 | 2024-09-01 00:00:00
 | Edmonton | 2024-08-01 00:00:00
 | Lewisham | 2024-08-01 00:00:00
 | Cricklewood | 2024-11-01 00:00:00
 | [NAME] | 2024-12-01 00:00:00
I need the data to be indexed in based on opening date (period 1) |  |  | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00
 | Total Cashflow
Filled for example of end required result | Edgware |  | -45982.67 | -21058.17 | -37244.67 | 549.1654000000053 | 10173.81039999999 | 13206.3046 | 15303.1926 | 17916.43317800001 | 19801.509478 | 23018.905778 | 16535.102078 | 24792.118378 | 26699.134678 | 28926.15097800001 | 30163.167278 | 32720.183578 | 188.4889780000085 | 39005.50317800001 | 40881.323178
 | Wembley
 | [NAME]
 | Wood Green 144
 | Edmonton
 | Lewisham
 | Cricklewood
 | [NAME]