Make a week key like 2026-W45
Turn the date November 4, 2026 into the week key 2026-W45 for weekly reports.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8-WEEKDAY(A8,2)+4 | Moves to the Thursday of the same week. | November 5, 2026 |
| 2 | YEAR( … ) | The year that Thursday falls in. | 2026 |
| 3 | &"-W"& | Adds -W between the year and the week. | "2026-W" |
| 4 | ISOWEEKNUM(A8) | The week of the year, from 1 to 53. | 45 |
| 5 | TEXT( … ,"00") | Writes the week with two digits, like 05. | "2026-W45" |
Each bracket works from the inside out. Weeks start on Monday, so early January can belong to the year before.
=YEAR(A8-WEEKDAY(A8,2)+4)&"-W"&TEXT(ISOWEEKNUM(A8),"00")How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own dates. Paste real dates into the green column of the Template tab. The week keys fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Near New Year, the key can show the year before or after. That's how week years work.
Microsoft's help: ISOWEEKNUM function
OTHER ROUTES YOU MIGHT LIKE

Make a calendar year-quarter text key
November 4, 2026 → 2026-Q4
Get the template →
Build a quarter-start date
2026 + quarter 4 → October 1, 2026
Get the template →
Build a quarter-end date
2026 + quarter 4 → December 31, 2026
Get the template →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →