Read a weekday-month timestamp
Turn English text like Wed Nov 04 14:30:15 2026 into a real date and time.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | MID( … )&"-"&MID( … )&"-"&RIGHT( … ) | Takes the day, month and year and joins them. | "04-Nov-2026" |
| 2 | DATEVALUE( … ) | Turns that text into a real date. | November 4, 2026 |
| 3 | TIMEVALUE(MID(A8,12,8)) | Takes the clock time and adds it. | … 2:30:15 PM |
Work from the inside out. MID takes characters by position: the month starts at 5, the day at 9, the time at 12. The weekday is skipped.
=DATEVALUE(MID(A8,9,2)&"-"&MID(A8,5,3)&"-"&RIGHT(A8,4))+TIMEVALUE(MID(A8,12,8))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 timestamps. Paste text like Wed Nov 04 14:30:15 2026 into the green column of the Template tab. The dates and times fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use English month names, in the same shape every time, with a two-digit day like 04. The weekday isn't checked, so a wrong one won't be caught.
Microsoft's help: DATEVALUE function
OTHER ROUTES YOU MIGHT LIKE

Read a yyyymmddhhmmss timestamp
20261104143015 → November 4, 2026 2:30:15 PM
Get the template →
Read a yyyymmdd hhmmss timestamp
20261104 143015 → November 4, 2026 2:30:15 PM
Get the template →
Read a timestamp split by a separator
4-Nov-2026 | 14:30:15 → November 4, 2026 2:30:15 PM
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →