Spreadsheet: 48903d1248194156-converting-daily-data-to-weekly-converting-daily-data-to-weekly
Sheet: Sheet1

Week number | Days | Prices
1 | 1990-01-01 00:00:00 | 96.5
1 | 1990-01-02 00:00:00 | 97
1 | 1990-01-03 00:00:00 | 96
1 | 1990-01-04 00:00:00 | 97.6 | highest price
1 | 1990-01-05 00:00:00 | 97.2
2 | 1990-01-08 00:00:00 | 98 | highest price
2 | 1990-01-09 00:00:00 | 97.4
2 | 1990-01-10 00:00:00 | 97.8
2 | 1990-01-11 00:00:00 | 96.9 |  |  |  | Week | highest price
3 | 1990-01-15 00:00:00 | 98.3 | highest price |  | 1 | 01 Jan 90 - 05 Jan 90 | 97.6
3 | 1990-01-16 00:00:00 | 96.5 |  |  | 2 | 08 Jan 90 - 11 Jan 90 | 98
3 | 1990-01-17 00:00:00 | 97 |  |  | 3 | 15 Jan 90 - 19 Jan 90 | 98.3
3 | 1990-01-18 00:00:00 | 96 |  |  | 4 | 22 Jan 90 - 26 Jan 90 | 98
3 | 1990-01-19 00:00:00 | 97.6 |  |  | 5 | 29 Jan 90 - 02 Feb 90 | 98.3
4 | 1990-01-22 00:00:00 | 97.2 |  |  | 6 | 05 Feb 90 - 09 Feb 90 | 98
4 | 1990-01-23 00:00:00 | 98 | highest price |  | 7 | 12 Feb 90 - 16 Feb 90 | 98.3
4 | 1990-01-24 00:00:00 | 97.4 |  |  | 8 | 19 Feb 90 - 23 Feb 90 | 98
4 | 1990-01-25 00:00:00 | 97.8 |  |  | 9 | 26 Feb 90 - 04 Mar 90 | 98.3
4 | 1990-01-26 00:00:00 | 96.9 |  |  | 10 | 05 Mar 90 - 11 Mar 90 | 98
5 | 1990-01-29 00:00:00 | 98.3 | highest price |  | 11 | 12 Mar 90 - 18 Mar 90 | 98.3
5 | 1990-01-30 00:00:00 | 96.5 |  |  | 12 | 19 Mar 90 - 25 Mar 90 | 98.3
5 | 1990-01-31 00:00:00 | 97 |  |  | 13 | 26 Mar 90 - 30 Mar 90 | 97.6
5 | 1990-02-01 00:00:00 | 96 |  |  | 14 | 02 Apr 90 - 06 Apr 90 | 98.3
5 | 1990-02-02 00:00:00 | 97.6 |  |  | 15 | #N/A | #N/A
6 | 1990-02-05 00:00:00 | 97.2 |  |  | 16 | #N/A | #N/A
6 | 1990-02-06 00:00:00 | 97.2 |  |  | 17 | #N/A | #N/A
6 | 1990-02-07 00:00:00 | 98 | highest price
6 | 1990-02-08 00:00:00 | 97.4
6 | 1990-02-09 00:00:00 | 97.8
7 | 1990-02-12 00:00:00 | 96.9
7 | 1990-02-13 00:00:00 | 98.3 | highest price
7 | 1990-02-14 00:00:00 | 96.5
7 | 1990-02-15 00:00:00 | 97
7 | 1990-02-16 00:00:00 | 96
8 | 1990-02-19 00:00:00 | 97.6
8 | 1990-02-20 00:00:00 | 96
8 | 1990-02-21 00:00:00 | 97.6
8 | 1990-02-22 00:00:00 | 97.2
8 | 1990-02-23 00:00:00 | 98 | highest price
9 | 1990-02-26 00:00:00 | 97.4
9 | 1990-02-27 00:00:00 | 97.8
9 | 1990-02-28 00:00:00 | 96.9
9 | 1990-03-01 00:00:00 | 98.3 | highest price
9 | 1990-03-02 00:00:00 | 96.5
9 | 1990-03-03 00:00:00 | 97
9 | 1990-03-04 00:00:00 | 96
10 | 1990-03-05 00:00:00 | 97.6
10 | 1990-03-06 00:00:00 | 97.2
10 | 1990-03-07 00:00:00 | 97.2
10 | 1990-03-08 00:00:00 | 98 | highest price
10 | 1990-03-09 00:00:00 | 97.4
10 | 1990-03-10 00:00:00 | 97.8
10 | 1990-03-11 00:00:00 | 96.9
11 | 1990-03-12 00:00:00 | 98.3 | highest price
11 | 1990-03-13 00:00:00 | 96.5
11 | 1990-03-14 00:00:00 | 97
11 | 1990-03-15 00:00:00 | 96
11 | 1990-03-16 00:00:00 | 97.6
11 | 1990-03-17 00:00:00 | 96
11 | 1990-03-18 00:00:00 | 97.6
12 | 1990-03-19 00:00:00 | 97.2
12 | 1990-03-20 00:00:00 | 98
12 | 1990-03-21 00:00:00 | 97.4
12 | 1990-03-22 00:00:00 | 97.8
12 | 1990-03-23 00:00:00 | 96.9
12 | 1990-03-24 00:00:00 | 98.3 | highest price
12 | 1990-03-25 00:00:00 | 96.5
13 | 1990-03-26 00:00:00 | 97
13 | 1990-03-27 00:00:00 | 96
13 | 1990-03-28 00:00:00 | 97.6 | highest price
13 | 1990-03-29 00:00:00 | 97.2
13 | 1990-03-30 00:00:00 | 97.2
14 | 1990-04-02 00:00:00 | 98
14 | 1990-04-03 00:00:00 | 97.4
14 | 1990-04-04 00:00:00 | 97.8
14 | 1990-04-05 00:00:00 | 96.9
14 | 1990-04-06 00:00:00 | 98.3 | highest price