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.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | For row 8 |
|---|---|---|---|
| 1 | VALUE(LEFT(A8,4)) | Reads the first 4 characters as the year, y. | 2026 |
| 2 | VALUE(MID(A8,7,2)) | Reads the 2 digits after W as the week, w. | 45 |
| 3 | VALUE(RIGHT(A8,1)) | Reads the last digit as the day, d. 1 is Monday. | 3 |
| 4 | DATE( … )-WEEKDAY( … )+ … | Finds week 1, then counts on weeks and days. | November 4, 2026 |
| 5 | LET( … ) | 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.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- 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.
- 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
OTHER ROUTES YOU MIGHT LIKE

Get the local date after a UTC offset
November 4, 2026 2:30:15 PM + 10 hours → November 5, 2026
Get the template →
Convert an mmyy valid-through code
0224 + 2000 → February 29, 2024
Get the template →
Convert month-year text to month start
November-2026 → November 1, 2026
Get the template →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →