Read an English date from a timestamp

Turn the timestamp 04-NOV-2026 14.30.15.123456 into a real date: November 4, 2026.

What you'll make

In Excel: 04-NOV-2026 14.30.15.123456 becomes November 4, 2026.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The timestamp, starting with the date."04-NOV-2026 14.30…"
2LEFT( … ,11)Keeps the first 11 characters: the date."04-NOV-2026"
3DATEVALUE( … )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(LEFT(A8,11))

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 timestamps. Paste timestamps like 04-NOV-2026 14.30.15.123456 into the green column of the Template tab. The dates fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Check that every timestamp starts with a two-digit day, like 04-NOV-2026. The time part is dropped, not converted.

Microsoft's help: DATEVALUE function