mysql> SELECT
-> dia,
-> WEEK(ADDDATE(dia, INTERVAL 1 DAY)) week_siguiente_dia
-> FROM dias;
+------------+--------------------+
| dia | week_siguiente_dia |
+------------+--------------------+
| 2017-11-01 | 44 |
| 2017-11-02 | 44 |
| 2017-11-03 | 44 |
| 2017-11-04 | 45 |
| 2017-11-05 | 45 |
| 2017-11-06 | 45 |
| 2017-11-07 | 45 |
| 2017-11-08 | 45 |
| 2017-11-09 | 45 |
| 2017-11-10 | 45 |
| 2017-11-11 | 46 |
| 2017-11-12 | 46 |
+------------+--------------------+
12 rows in set (0.00 sec)
mysql> SELECT
-> dia,
-> WEEK(ADDDATE(dia, INTERVAL 1 DAY)) week_siguiente_dia
-> FROM dias
-> WHERE
-> WEEK(ADDDATE(dia, INTERVAL 1 DAY)) = 45;
+------------+--------------------+
| dia | week_siguiente_dia |
+------------+--------------------+
| 2017-11-04 | 45 |
| 2017-11-05 | 45 |
| 2017-11-06 | 45 |
| 2017-11-07 | 45 |
| 2017-11-08 | 45 |
| 2017-11-09 | 45 |
| 2017-11-10 | 45 |
+------------+--------------------+
7 rows in set (0.00 sec)