Spreadsheet: 92813d1292354036-months-and-weeks-calculation-example
Sheet: Calculations

 | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | TOTAL |  |  |  |  |  | 4 wk | 5wk
Total Numbers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 1 | 0.2278 | 0.2267
 | 2589 | 2724 | 2483 | 2852 | 3468 | 3448 | 2917 | 3119 | 4018 | 3885 | 3657 | 3600 | 38760 |  | #N/A |  |  | Week 2 | 0.2037 | 0.1843
Group A | 1959 | 2125 | 2001 | 2159 | 2660 | 2629 | 2234 | 2392 | 3041 | 2981 | 2784 | 2783 | 29748 |  |  |  |  | Week 3 | 0.2627 | 0.1614
Group B | 630 | 599 | 482 | 693 | 808 | 819 | 683 | 727 | 977 | 904 | 873 | 817 | 9012 |  |  |  |  | Week 4 | 0.3058 | 0.1812
 |  |  |  |  |  |  |  |  |  |  |  |  | 38760 |  |  |  |  | Week 5 |  | 0.2464
 | 1959 | 2125 | 2001 | 2159 | 2660 | 2629 | 2234 | 2392 | 3041 | 2981 | 2784 | 2783 | 29748
 | 630 | 599 | 482 | 693 | 808 | 819 | 683 | 727 | 977 | 904 | 873 | 817 | 9012
 | Group A | Group B
2010-10-01 00:00:00 | 444.1053 | 142.821
2010-10-08 00:00:00 | 361.0437 | 116.109
2010-10-15 00:00:00 | 316.1826 | 101.682
2010-10-22 00:00:00 | 354.9708 | 114.156
2010-10-29 00:00:00 | 482.6976 | 155.232
2010-11-05 00:00:00 | 484.075 | 136.4522
2010-11-12 00:00:00 | 432.8625000000001 | 122.0163
2010-11-19 00:00:00 | 558.2375 | 157.3573
2010-11-26 00:00:00 | 649.8249999999999 | 183.1742
2010-12-03 00:00:00 | 453.6267 | 109.2694
2010-12-10 00:00:00 | 368.7843 | 88.8326
2010-12-17 00:00:00 | 322.9614 | 77.79480000000001
2010-12-24 00:00:00 | 362.5812 | 87.3384
2010-12-31 00:00:00 | 493.0464 | 118.7648
2011-01-07 00:00:00 | 491.8202 | 157.8654
2011-01-14 00:00:00 | 439.7883 | 141.1641
2011-01-21 00:00:00 | 567.1693 | 182.0511
2011-01-28 00:00:00 | 660.2221999999999 | 211.9194
2011-02-04 00:00:00 | 605.948 | 184.0624
2011-02-11 00:00:00 | 541.8420000000001 | 164.5896
2011-02-18 00:00:00 | 698.7819999999999 | 212.2616
2011-02-25 00:00:00 | 813.4279999999999 | 247.0864
2011-03-04 00:00:00 | 598.8862 | 186.5682
2011-03-11 00:00:00 | 535.5273000000001 | 166.8303
2011-03-18 00:00:00 | 690.6383 | 215.1513
2011-03-25 00:00:00 | 803.9481999999999 | 250.4502
2011-04-01 00:00:00 | 506.4478 | 154.8361
2011-04-08 00:00:00 | 411.7262 | 125.8769
2011-04-15 00:00:00 | 360.5676 | 110.2362
2011-04-22 00:00:00 | 404.8008 | 123.7596
2011-04-29 00:00:00 | 550.4576000000001 | 168.2912
2011-05-06 00:00:00 | 544.8976 | 165.6106
2011-05-13 00:00:00 | 487.2504000000001 | 148.0899
2011-05-20 00:00:00 | 628.3783999999999 | 190.9829
2011-05-27 00:00:00 | 731.4735999999999 | 222.3166
2011-06-03 00:00:00 | 692.7398000000001 | 222.5606
2011-06-10 00:00:00 | 619.4517000000001 | 199.0149
2011-06-17 00:00:00 | 798.8706999999999 | 256.6579
2011-06-24 00:00:00 | 929.9377999999999 | 298.7666
2011-07-01 00:00:00 | 675.7927000000001 | 204.9368
2011-07-08 00:00:00 | 549.3983 | 166.6072
2011-07-15 00:00:00 | 481.1334000000001 | 145.9056
2011-07-22 00:00:00 | 540.1572 | 163.8048
2011-07-29 00:00:00 | 734.5184 | 222.7456
2011-08-05 00:00:00 | 634.1952 | 198.8694
2011-08-12 00:00:00 | 567.1008 | 177.8301
2011-08-19 00:00:00 | 731.3568 | 229.3371
2011-08-26 00:00:00 | 851.3471999999999 | 266.9634
2011-09-02 00:00:00 | 633.9674 | 186.1126
2011-09-09 00:00:00 | 566.8971 | 166.4229
2011-09-16 00:00:00 | 731.0941 | 214.6259
2011-09-23 00:00:00 | 851.0413999999998 | 249.8386
2011-09-30 00:00:00