Spreadsheet: 878969d1726363300-changing-daily-numbers-to-weekly-numbers-daily-temp-highs-and-lows
Sheet: Daily Temps High and Low

 |  |  |  | Date | High Temp | Low Temp | Week |  |  | Without Helper column |  | Using Helper column H
 |  |  |  | 2023-08-01 00:00:00 | 80 | 65 |  |  | Week | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  |  | 2023-08-02 00:00:00 | 81 | 66 |  |  | 31
 |  |  |  | 2023-08-03 00:00:00 | 90 | 75
 |  |  |  | 2023-08-04 00:00:00 | 85 | 70
 |  |  |  | 2023-08-05 00:00:00 | 76 | 61
 |  |  |  | 2023-08-06 00:00:00 | 75 | 60
 |  |  |  | 2023-08-07 00:00:00 | 80 | 65
 |  |  |  | 2023-08-08 00:00:00 | 81 | 66
 |  |  |  | 2023-08-09 00:00:00 | 86 | 71
 |  |  |  | 2023-08-10 00:00:00 | 78 | 63
 |  |  |  | 2023-08-11 00:00:00 | 80 | 65
 |  |  |  | 2023-08-12 00:00:00 | 90 | 75
 |  |  |  | 2023-08-13 00:00:00 | 92 | 77
 |  |  |  | 2023-08-14 00:00:00 | 92 | 77
 |  |  |  | 2023-08-15 00:00:00 | 93 | 78 |  |  |  | With week number in J3,
 |  |  |  | 2023-08-16 00:00:00 | 100 | 85
 |  |  |  | 2023-08-17 00:00:00 | 90 | 75
 |  |  |  | 2023-08-18 00:00:00 | 95 | 80
 |  |  |  | 2023-08-19 00:00:00 | 80 | 65
 |  |  |  | 2023-08-20 00:00:00 | 80 | 65
 |  |  |  | 2023-08-21 00:00:00 | 75 | 60
 |  |  |  | 2023-08-22 00:00:00 | 78 | 63
 |  |  |  | 2023-08-23 00:00:00 | 76 | 61
 |  |  |  | 2023-08-24 00:00:00 | 80 | 65
 |  |  |  | 2023-08-25 00:00:00 | 82 | 67
 |  |  |  | 2023-08-26 00:00:00 | 83 | 68
 |  |  |  | 2023-08-27 00:00:00 | 86 | 71
 |  |  |  | 2023-08-28 00:00:00 | 89 | 74
 |  |  |  | 2023-08-29 00:00:00 | 89 | 74
 |  |  |  | 2023-08-30 00:00:00 | 89 | 74
 |  |  |  | 2023-08-31 00:00:00 | 90 | 75
 |  |  |  | 2023-09-01 00:00:00 | 94 | 79
 |  |  |  | 2023-09-02 00:00:00 | 75 | 60
 |  |  |  | 2023-09-03 00:00:00 | 75 | 60
 |  |  |  | 2023-09-04 00:00:00 | 60 | 45
 |  |  |  | 2023-09-05 00:00:00 | 65 | 50
 |  |  |  | 2023-09-06 00:00:00 | 70 | 55
 |  |  |  | 2023-09-07 00:00:00 | 75 | 60
 |  |  |  | 2023-09-08 00:00:00 | 72 | 57
 |  |  |  | 2023-09-09 00:00:00 | 76 | 61
 |  |  |  | 2023-09-10 00:00:00 | 75 | 60
 |  |  |  | 2023-09-11 00:00:00 | 78 | 63
 |  |  |  | 2023-09-12 00:00:00 | 75 | 60
 |  |  |  | 2023-09-13 00:00:00 | 76 | 61
 |  |  |  | 2023-09-14 00:00:00 | 55 | 40
 |  |  |  | 2023-09-15 00:00:00 | 54 | 39
 |  |  |  | 2023-09-16 00:00:00 | 50 | 35
 |  |  |  | 2023-09-17 00:00:00 | 56 | 41
 |  |  |  | 2023-09-18 00:00:00 | 58 | 43
 |  |  |  | 2023-09-19 00:00:00 | 90 | 75
 |  |  |  | 2023-09-20 00:00:00 | 85 | 70
 |  |  |  | 2023-09-21 00:00:00 | 80 | 65
 |  |  |  | 2023-09-22 00:00:00 | 80 | 65
 |  |  |  | 2023-09-23 00:00:00 | 75 | 60
 |  |  |  | 2023-09-24 00:00:00 | 76 | 61
 |  |  |  | 2023-09-25 00:00:00 | 77 | 62
 |  |  |  | 2023-09-26 00:00:00 | 78 | 63
 |  |  |  | 2023-09-27 00:00:00 | 80 | 65
 |  |  |  | 2023-09-28 00:00:00 | 82 | 67
 |  |  |  | 2023-09-29 00:00:00 | 86 | 71
 |  |  |  | 2023-09-30 00:00:00 | 86 | 71
 |  |  |  | 2023-10-01 00:00:00 | 78 | 63
 |  |  |  | 2023-10-02 00:00:00 | 76 | 61
 |  |  |  | 2023-10-03 00:00:00 | 74 | 59
 |  |  |  | 2023-10-04 00:00:00 | 79 | 64
 |  |  |  | 2023-10-05 00:00:00 | 80 | 65
 |  |  |  | 2023-10-06 00:00:00 | 75 | 60
 |  |  |  | 2023-10-07 00:00:00 | 60 | 45
 |  |  |  | 2023-10-08 00:00:00 | 60 | 45
 |  |  |  | 2023-10-09 00:00:00 | 62 | 47
 |  |  |  | 2023-10-10 00:00:00 | 63 | 48
 |  |  |  | 2023-10-11 00:00:00 | 65 | 50
 |  |  |  | 2023-10-12 00:00:00 | 67 | 52
 |  |  |  | 2023-10-13 00:00:00 | 64 | 49
 |  |  |  | 2023-10-14 00:00:00 | 63 | 48
 |  |  |  | 2023-10-15 00:00:00 | 65 | 50
 |  |  |  | 2023-10-16 00:00:00 | 66 | 51
 |  |  |  | 2023-10-17 00:00:00 | 63 | 48