Check and read 2026-11-04T14:30:15
Turn 2026-11-04T14:30:15 into a date and time. Impossible ones show Review timestamp.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | DATEVALUE( … ) | Reads the first 10 characters as a date. | November 4, 2026 |
| 2 | TIMEVALUE( … ) | Adds the clock time after the T. LET calls it x. | November 4, 2026 2:30:15 PM |
| 3 | AND( … ) | Checks x writes back as the same text, after 1900. | TRUE |
| 4 | IF( … ,x, … ) | Shows x, or Review timestamp if part 3 fails. | November 4, 2026 2:30:15 PM |
| 5 | IFERROR(LET( … )) | Shows Review timestamp if Excel can't read it. | November 4, 2026 2:30:15 PM |
Excel works from the inside out. 2026-02-30 can't write back as itself, so it fails.
=IFERROR(LET(x,DATEVALUE(LEFT(A8,10))+TIMEVALUE(MID(A8,12,8)),IF(AND(YEAR(x)>=1901,TEXT(x,"yyyy-mm-dd""T""hh:mm:ss")=A8),x,"Review timestamp")),"Review timestamp")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 timestamps like 2026-11-04T14:30:15 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
Check every Review timestamp row. A zone like Z or +01:00 on the end also shows Review.
Microsoft's help: DATEVALUE function
OTHER ROUTES YOU MIGHT LIKE

Check timestamp text with milliseconds
2026-11-04T14:30:15.123 → 11/4/2026 2:30:15.123 PM, but .12 → Review timestamp
Get the template →
Clean a mixed column of clock times
Text 9:05 AM → 9:05:00 AM; timestamps keep their time
Get the template →
Keep real timestamps, check the text
2026-11-04T14:30:15 → November 4, 2026 2:30:15 PM; real timestamps stay
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →