=TODAY()+6*7| from November 23 | Monday, January 4, 2027 |
| from November 24 | Tuesday, January 5, 2027 |
| from November 25 | Wednesday, January 6, 2027 |
| from November 26 | Thursday, January 7, 2027 |
| from November 27 | Friday, January 8, 2027 |
| from November 28 | Saturday, January 9, 2027 |
6 weeks from today is Sunday, January 3, 2027.
6 weeks from today falls on a Sunday.
6 weeks from now is Sunday, January 3, 2027 — "from now" and "from today" mean the same thing here, counting from today's date.
6 weeks is 42 days.