Spreadsheet: 719532d1613712271-create-rolling-avg-w-dynamic-range-based-on-a-year-but-not-every-day-has-an-entry-rolling-average-help-please-ans
Sheet: Sheet1

Date | [NAME] | 12 month rolling average | 13 month rolling average
2009-01-30 00:00:00 | 1.500000001396984
2009-01-30 00:00:00 | 10.83333333372138
2009-02-06 00:00:00 | 27.99444444535766
2009-02-06 00:00:00 | 2.166666666744277
2009-02-14 00:00:00 | 1877.063888889388
2009-02-24 00:00:00 | 1282.613888889318
2009-03-09 00:00:00 | 2985.441666666884
2009-03-31 00:00:00 | 3341.702777778846
2009-03-31 00:00:00 | 63.50000000093132
2009-04-03 00:00:00 | 559.0833333326736
2009-04-03 00:00:00 | 0.05555555631872267
2009-04-04 00:00:00 | 171.2777777784504
2009-04-04 00:00:00 | 4.3611111107748
2009-04-11 00:00:00 | 2.972222222015262
2009-04-11 00:00:00 | 28.08333333407063
2009-04-11 00:00:00 | 0.08333333360496908
2009-04-22 00:00:00 | 124.1111111099599
2009-04-29 00:00:00 | 1606.177777777193
2009-04-29 00:00:00 | 2.027777776820585
2009-05-01 00:00:00 | 399.4194444443565
2009-05-11 00:00:00 | 2514.380555555108
2009-05-12 00:00:00 | 173.838888889295
2009-05-15 00:00:00 | 419.9777777778218
2009-05-17 00:00:00 | 366.616666666232
2009-05-17 00:00:00 | 1.052777777658775
2009-05-25 00:00:00 | 0.1388888899236917
2009-05-25 00:00:00 | 0.7500000006984919
2009-06-24 00:00:00 | 2.499999999417923
2009-06-26 00:00:00 | 473.0666666664183
2009-06-26 00:00:00 | 10.08333333476912
2009-06-27 00:00:00 | 195.2222222217824
2009-06-27 00:00:00 | 75.27777777810115
2009-06-28 00:00:00 | 29.3888888892252
2009-06-28 00:00:00 | 208.0583333334653
2009-06-29 00:00:00 | 104.0861111122649
2009-07-03 00:00:00 | 1094.063888890087
2009-08-02 00:00:00 | 0.002777778427116573
2009-08-03 00:00:00 | 0.002777778427116573
2009-08-03 00:00:00 | 0.3333333326736465
2009-08-03 00:00:00 | 0.1666666672099382
2009-08-03 00:00:00 | 0.6666666670935228
2009-08-03 00:00:00 | 0.4166666680248454
2009-08-03 00:00:00 | 12.69444444507826
2009-08-03 00:00:00 | 3.055555555620231
2009-09-06 00:00:00 | 2293.072222222108
2009-09-07 00:00:00 | 0.002777778427116573
2009-09-08 00:00:00 | 0.002777778427116573
2009-09-09 00:00:00 | 0.002777778427116573
2009-09-10 00:00:00 | 0.002777778427116573
2009-09-14 00:00:00 | 8.749999998835847
2009-09-14 00:00:00 | 0.08333333360496908
2009-09-22 00:00:00 | 1943.144444444915
2009-09-23 00:00:00 | 288.2527777785435
2009-09-24 00:00:00 | 92.22222222131677
2009-09-24 00:00:00 | 0.02777777903247625
2009-09-24 00:00:00 | 0.05555555457249284
2009-09-24 00:00:00 | 0
2009-09-24 00:00:00 | 2.499999999417923
2009-09-30 00:00:00 | 1412.475000000559
2009-10-28 00:00:00 | 0.002777778427116573
2009-10-29 00:00:00 | 0.002777778427116573
2009-10-30 00:00:00 | 0.002777778427116573
2009-10-31 00:00:00 | 0.002777778427116573
2009-11-01 00:00:00 | 0.002777778427116573
2009-11-02 00:00:00 | 0.002777778427116573 |  |  |  |  | Expected
2009-11-03 00:00:00 | 0.002777778427116573
2010-05-03 00:00:00 | 0.1388888881774619
2010-05-04 00:00:00 | 0.002777778427116573
2010-05-04 00:00:00 | 59.66666666732635
2010-05-08 00:00:00 | 992.8888888884103
2010-05-09 00:00:00 | 130.6416666659061
2010-05-11 00:00:00 | 548.5277777787996
2010-05-16 00:00:00 | 1090.602777778404
2010-05-22 00:00:00 | 1594.880555556156
2010-05-22 00:00:00 | 0.6944444443797693
2010-05-25 00:00:00 | 573.6138888885034
2010-05-25 00:00:00 | 0.6666666670935228 |  |  |  |  |  |  | 0.1
2010-05-26 00:00:00 | 285.2222222217824
2010-05-26 00:00:00 | 56.44166666606907
2010-05-27 00:00:00 | 76.46944444393739
2010-05-29 00:00:00 | 470.4222222219687
2010-05-30 00:00:00 | 424.8805555561557
2010-05-31 00:00:00 | 0.002777778427116573
2010-06-01 00:00:00 | 0.002777778427116573
2010-06-02 00:00:00 | 259.0277777781012
2010-06-05 00:00:00 | 748.666666665813
2010-06-07 00:00:00 | 502.4444444454275
2010-06-09 00:00:00 | 500.7250000006752
2010-06-14 00:00:00 | 1187.561111110845
2010-06-15 00:00:00 | 149.194444444729
2010-06-19 00:00:00 | 1094.133333333302
2010-06-20 00:00:00 | 172.4194444448221
2010-06-26 00:00:00 | 1339.974999999977
2010-06-26 00:00:00 | 37.44444444368128
2010-07-04 00:00:00 | 1757.702777777449
2010-07-05 00:00:00 | 0.002777778427116573
2010-07-10 00:00:00 | 1232.25277777703
2010-07-10 00:00:00 | 63.69444444542751
2010-07-11 00:00:00 | 186.8833333341172
2010-07-12 00:00:00 | 212.3916666669538
2010-07-12 00:00:00 | 7.555555554572493
2010-07-12 00:00:00 | 20.86111111217178
2010-07-13 00:00:00 | 0.002777778427116573
2010-07-16 00:00:00 | 827.3416666657431
2010-07-18 00:00:00 | 378.6638888897141
2010-07-20 00:00:00 | 472.225000000326
2010-07-21 00:00:00 | 0.002777778427116573
2010-07-22 00:00:00 | 0.002777778427116573
2010-07-24 00:00:00 | 522.7249999990454
2010-07-29 00:00:00 | 1256.280555555713
2010-07-30 00:00:00 | 0.002777778427116573
2010-07-31 00:00:00 | 0.002777778427116573
2010-08-01 00:00:00 | 0.002777778427116573
2010-08-16 00:00:00 | 0.3333333344198763
2010-08-20 00:00:00 | 907.1166666661156
2010-08-21 00:00:00 | 284.2222222220153
2010-08-22 00:00:00 | 0.002777778427116573
2010-08-23 00:00:00 | 0.002777778427116573
2010-08-24 00:00:00 | 0.002777778427116573
2010-08-25 00:00:00 | 0.002777778427116573
2010-08-26 00:00:00 | 0.002777778427116573
2010-08-27 00:00:00 | 0.002777778427116573
2010-08-28 00:00:00 | 0.002777778427116573
2010-09-05 00:00:00 | 2146.566666667932
2010-09-06 00:00:00 | 0.002777778427116573
2010-09-07 00:00:00 | 0.002777778427116573
2010-09-07 00:00:00 | 0.833333334303461
2010-09-17 00:00:00 | 2444.147222221945
2010-09-23 00:00:00 | 1392.091666667839
2010-09-30 00:00:00 | 1539.949999999953
2010-09-30 00:00:00 | 0.6666666670935228
2010-10-04 00:00:00 | 1015.583333332906
2010-10-13 00:00:00 | 2114.900000001071
2010-10-19 00:00:00 | 1353.755555555108
2010-10-20 00:00:00 | 0.002777778427116573
2010-10-20 00:00:00 | 5.249999999650754
2010-10-23 00:00:00 | 728.0027777783107
2010-10-24 00:00:00 | 0.002777778427116573
2010-11-01 00:00:00 | 1924.850000000442
2010-11-04 00:00:00 | 841.8916666670702
2010-11-05 00:00:00 | 163.3333333331393
2010-11-05 00:00:00 | 0.1944444444961846
2010-11-10 00:00:00 | 1263.008333332837
2010-11-13 00:00:00 | 787.4722222227138
2010-11-16 00:00:00 | 591.7555555561557
2010-11-16 00:00:00 | 70.94722222303972
2010-11-16 00:00:00 | 1.277777777868323
2010-11-16 00:00:00 | 1.499999999650754
2010-11-20 00:00:00 | 806.3111111096805
2010-11-21 00:00:00 | 0.002777778427116573
2010-11-22 00:00:00 | 0.002777778427116573
2010-11-23 00:00:00 | 116.0416666668607
2010-11-24 00:00:00 | 0.002777778427116573
2010-11-25 00:00:00 | 0.002777778427116573
2010-11-26 00:00:00 | 0.002777778427116573
2010-11-27 00:00:00 | 0.002777778427116573
2010-11-27 00:00:00 | 22.77777777810115
2010-11-30 00:00:00 | 726.0027777770301
2010-11-30 00:00:00 | 27.50277777726296
2011-01-03 00:00:00 | 346.0305555554805
2011-01-05 00:00:00 | 401.8305555550614
2011-01-08 00:00:00 | 712.3916666675359
2011-01-08 00:00:00 | 5.999999998603016
2011-01-08 00:00:00 | 2.916666667442769
2011-01-08 00:00:00 | 0.08333333360496908
2011-01-14 00:00:00 | 1355.255555556505
2011-01-14 00:00:00 | 5.083333332440816
2011-01-19 00:00:00 | 1086.197222221526
2011-01-30 00:00:00 | 2755.411111110589
2011-01-31 00:00:00 | 0.002777778427116573
2011-02-01 00:00:00 | 0.002777778427116573
2011-02-02 00:00:00 | 0.002777778427116573
2011-02-03 00:00:00 | 0.002777778427116573
2011-02-04 00:00:00 | 0.002777778427116573
2011-02-05 00:00:00 | 0.002777778427116573
2011-02-05 00:00:00 | 5.111111111473292
2011-02-10 00:00:00 | 1277.58611111145
2011-02-11 00:00:00 | 0.002777778427116573
2011-02-11 00:00:00 | 19.24999999988358
2011-02-12 00:00:00 | 300.2777777781012
2011-02-16 00:00:00 | 787.1999999997206
2011-02-16 00:00:00 | 0.222222221782431
2011-02-19 00:00:00 | 840.727777776774
2011-02-22 00:00:00 | 669.997222222737
2011-06-01 00:00:00 | 3057.41388888855
2011-06-08 00:00:00 | 1660.14444444445
2011-06-12 00:00:00 | 874.1694444447057
2011-06-13 00:00:00 | 255.7805555546656
2011-06-13 00:00:00 | 0.02777777728624642
2011-06-13 00:00:00 | 0.666666665347293
2011-06-16 00:00:00 | 687.8916666662553
2011-06-17 00:00:00 | 289.5805555558763
2011-06-22 00:00:00 | 1074.419444444356
2011-06-23 00:00:00 | 0.002777778427116573
2011-06-26 00:00:00 | 746.344444443821
2011-06-26 00:00:00 | 0.02777777728624642
2011-06-26 00:00:00 | 9.530555556993932