Convert mmddyy text to yyyy-mm-dd

Turn the text 110426 and the century 2000 into the text 2026-11-04.

What you'll make

In Excel: 110426 + 2000 becomes 2026-11-04.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1B8+RIGHT(A8,2)Adds your century to the last 2 digits: the year.2026
2LEFT(A8,2)Takes the first 2 digits: the month."11"
3MID(A8,3,2)Takes 2 digits from the 3rd: the day."04"
4DATE( … )Puts them together as a real date.November 4, 2026
5TEXT( … ,"yyyy-mm-dd")Writes that date as yyyy-mm-dd text."2026-11-04"

Each bracket wraps the one above it, so Excel works from the inside out. Part 5 holds the yyyy-mm-dd pattern.

=TEXT(DATE(B8+RIGHT(A8,2),LEFT(A8,2),MID(A8,3,2)),"yyyy-mm-dd")

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 six-digit text like 110426 and its century, like 2000, into the green columns of the Template tab. The yyyy-mm-dd text fills in by itself.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Choose the century for each row yourself: 1900 turns 80 into 1980, and 2000 turns 26 into 2026. A day that doesn't exist rolls into the next month, so check odd dates.

Microsoft's help: TEXT function