Spreadsheet: 376032d1423469172-need-help-to-find-the-average-of-a-range-between-two-cells-in-a-different-column-dailyrecordstest
Sheet: Sheet1

DAILY RECORDS LOG |  |  |  |  |  | Week | Daily Weight | Weekly | today= |  | start date |  |  |  |  |  |  |  | days | weeks | months
Date | Weight | Protein | Carbs | Fat | Calories | Number | Change | change |  |  | last date
2015-02-08 00:00:00 | 151 | 109.26 | 55.4 | 56.7 | 1156.12
2015-02-07 00:00:00 | 151 | 109.26 | 55.4 | 56.7 | 1156.12
2015-02-06 00:00:00 | 150.5 | 109.26 | 55.4 | 56.7 | 1156.12 |  |  |  |  |  |  |  |  |  |  |  | month
2015-02-05 00:00:00 | 149.5 | 109.26 | 55.4 | 56.7 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 1 | 1
2015-02-04 00:00:00 | 150 | 109.26 | 55.4 | 56.7 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 2 | 1 |  | 8
2015-02-03 00:00:00 | 149 | 109.26 | 55.4 | 56.7 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 3 | 1 |  | 12
2015-02-02 00:00:00 | 149.5 | 109.26 | 55.4 | 56.7 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 4 | 1 |  | 16
2015-02-01 00:00:00 | 149 | 109.26 | 55.4 | 56.7 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 5 | 2 |  | 20
2015-01-31 00:00:00 | 149 | 109.26 | 55.4 | 56.7 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 6 | 2 |  | 24
2015-01-30 00:00:00 | 148.5 | 109.26 | 55.4 | 56.7 | 1156.12 |  |  |  |  | from | 2015-01-08 00:00:00 | 2015-01-20 00:00:00 |  |  |  | 7 | 2 |  | 28
2015-01-29 00:00:00 | 149 | 109.26 | 55.4 | 56.7 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 8 | 2 |  | 32
2015-01-28 00:00:00 | 148 | 109.26 | 55.4 | 56.7 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 9 | 3 |  | 36
2015-01-27 00:00:00 | 147 | 109.26 | 55.4 | 56.7 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 10 | 3 |  | 40
2015-01-26 00:00:00 | 147 | 109.26 | 55.4 | 56.7 | 1156.12 |  |  |  |  | averaged | ___________ | calories |  |  |  | 11 | 3 |  | 44
2015-01-25 00:00:00 | 147 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 12 | 3 |  | 48
2015-01-24 00:00:00 | 146.5 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 13 | 4 |  | 52
2015-01-23 00:00:00 | 147 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 14 | 4 |  | 56
2015-01-22 00:00:00 | 145.5 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 15 | 4 |  | 60
2015-01-21 00:00:00 | 146 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 16 | 4 |  | 64
2015-01-20 00:00:00 | 146 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 17 | 5 |  | 68
2015-01-19 00:00:00 | 145.5 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 18 | 5 |  | 72
2015-01-18 00:00:00 | 145 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 19 | 5 |  | 76
2015-01-17 00:00:00 | 145 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 20 | 5 |  | 80
2015-01-16 00:00:00 | 145.5 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 21 | 6 |  | 84
2015-01-15 00:00:00 | 146 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 22 | 6 |  | 88
2015-01-14 00:00:00 | 145 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 23 | 6 |  | 92
2015-01-13 00:00:00 | 144.5 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12 |  |  |  |  |  |  |  |  |  |  | 24 | 6 |  | 96
2015-01-12 00:00:00 | 144 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12
2015-01-11 00:00:00 | 144 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12
2015-01-10 00:00:00 | 142.5 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12
2015-01-09 00:00:00 | 142 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12
2015-01-08 00:00:00 | 143 | 109.2599999999999 | 55.4 | 56.69999999999999 | 1156.12
2015-01-07 00:00:00 | 143 | 112.2599999999999 | 57.4 | 60.69999999999999 | 1216.12
2015-01-06 00:00:00 | 142.5 | 112.2599999999999 | 57.4 | 60.69999999999999 | 1216.12