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