Convert 2026-W45-3 text to a date

Turn the text 2026-W45-3 (week 45, day 3) into a real date: November 4, 2026.

What you'll make

In Excel: 2026-W45-3 becomes November 4, 2026.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesFor row 8
1VALUE(LEFT(A8,4))Reads the first 4 characters as the year, y.2026
2VALUE(MID(A8,7,2))Reads the 2 digits after W as the week, w.45
3VALUE(RIGHT(A8,1))Reads the last digit as the day, d. 1 is Monday.3
4DATE( … )-WEEKDAY( … )+ …Finds week 1, then counts on weeks and days.November 4, 2026
5LET( … )Gives parts 1 to 3 short names for part 4.November 4, 2026

Week 1 is the week that holds January 4.

=LET(y,VALUE(LEFT(A8,4)),w,VALUE(MID(A8,7,2)),d,VALUE(RIGHT(A8,1)),DATE(y,1,4)-WEEKDAY(DATE(y,1,4),2)+7*(w-1)+d)

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 week dates like 2026-W45-3 into the green column of the Template tab. The dates fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

This reads the shape, not the week. A week that doesn't exist, like week 54, rolls into the next year, so check odd ones.

Microsoft's help: LET function