Convert a date following a colon label
Turn the text DOB: 4-Nov-2026 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 | A8 | The label and date, written as text. | "DOB: 4-Nov-2026" |
| 2 | TEXTAFTER( … ,":") | Keeps what comes after the colon. | " 4-Nov-2026" |
| 3 | TRIM( … ) | Removes the spaces at the ends. | "4-Nov-2026" |
| 4 | DATEVALUE( … ) | Reads the text and turns it into a real date. | November 4, 2026 |
Each bracket wraps the one above it, so Excel works from the inside out.
=DATEVALUE(TRIM(TEXTAFTER(A8,":")))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 labeled dates like DOB: 4-Nov-2026 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
Excel reads dates using your computer's settings. Month names are safe, but numbers-only dates like 04/11/2026 can swap day and month.
Microsoft's help: TEXTAFTER function
OTHER ROUTES YOU MIGHT LIKE

Convert dates with nonbreaking spaces
Nov[NBSP]4,[NBSP]2026 → November 4, 2026
Get the template →
Convert mm/dd/yy text with a century
11/04/26 + 2000 → November 4, 2026
Get the template →
Convert mmddyy text with a century
110426 + 2000 → November 4, 2026
Get the template →
Show a letter date as November 5, 2026
11/5/2026 → November 5, 2026
Take this route →