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

In Excel: January 1, 2027 becomes 2026-W53.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8-WEEKDAY(A8,2)+4Moves to the Thursday of the same week.November 5, 2026
2YEAR( … )The year that Thursday falls in.2026
3&"-W"&Adds -W between the year and the week."2026-W"
4ISOWEEKNUM(A8)The week of the year, from 1 to 53.45
5TEXT( … ,"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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own dates. Paste real dates into the green column of the Template tab. The week keys fill in by themselves.
  3. 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