Convert variable-width year-first dates
Turn the text 2026-11-4 into a real date: November 4, 2026.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TEXTBEFORE(A8,"-") | Keeps the text before the first hyphen: the year. | "2026" |
| 2 | TEXTBEFORE(TEXTAFTER( … )) | Keeps the text between the hyphens: the month. | "11" |
| 3 | TEXTAFTER(A8,"-",-1) | Keeps the text after the last hyphen: the day. | "4" |
| 4 | DATE( … ) | Puts them together as a real date. | November 4, 2026 |
The month and day can have one or two digits.
=DATE(TEXTBEFORE(A8,"-"),TEXTBEFORE(TEXTAFTER(A8,"-"),"-"),TEXTAFTER(A8,"-",-1))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 date text like 2026-1-4 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
Check that your dates are year, month, day. A day that doesn't exist, like 2026-2-30, rolls into March.
Microsoft's help: TEXTBEFORE function
OTHER ROUTES YOU MIGHT LIKE

Convert m/d/yyyy text to a date
11/4/2026 → November 4, 2026
Get the template →
Convert d/m/yyyy text to a date
4/11/2026 → November 4, 2026
Get the template →
Read a date between two markers
<dob>2026-11-04</dob> → November 4, 2026
Get the template →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →