Build yyyy-mm-dd text from date parts
Turn 2026, 11 and 4 into the text 2026-11-04 for a system that needs it.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | DATE(A8,B8,C8) | Puts the year, month and day together as a date. | November 4, 2026 |
| 2 | "yyyy-mm-dd" | The pattern: 4-digit year, month, day. | "yyyy-mm-dd" |
| 3 | TEXT( … ) | Writes the date in that pattern as text. | "2026-11-04" |
Months and days always get two digits, so 4 becomes 04.
=TEXT(DATE(A8,B8,C8),"yyyy-mm-dd")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 the year, month and day into the green columns of the Template tab. The date text fills in by itself.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
A month of 13 or a day of 32 rolls into the next month. Check any result that looks odd.
Microsoft's help: TEXT function
OTHER ROUTES YOU MIGHT LIKE

Format a Workday Adaptive period label
November 4, 2026 → nov-2026
Get the template →
Export a UTC date as Unix seconds
November 4, 2026 → Unix seconds 1793750400
Get the template →
Export a UTC date as Unix milliseconds
November 4, 2026 → Unix milliseconds 1793750400000
Get the template →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →