Read 20261104143015.0Z timestamps
Turn Active Directory codes like 20261104143015.0Z into a date and time. Flags others.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | AND(LEN(A8)=17, … ".0Z") | Checks for 17 characters ending in .0Z. | TRUE |
| 2 | DATE(LEFT( … )) | Reads the year, month and day as a real date. | November 4, 2026 |
| 3 | TIME(MID( … )) | Adds the hour, minutes and seconds. | November 4, 2026 2:30:15 PM |
| 4 | "Review time code" | The message when the code has another ending. | Not used for row 8 |
| 5 | IF( … ) | Shows the date and time, or else the message. | November 4, 2026 2:30:15 PM |
The Z means UTC, so the result is UTC too. Codes ending only in Z or an offset are flagged.
=IF(AND(LEN(A8)=17,RIGHT(A8,3)=".0Z"),DATE(LEFT(A8,4),MID(A8,5,2),MID(A8,7,2))+TIME(MID(A8,9,2),MID(A8,11,2),MID(A8,13,2)),"Review time code")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 codes. Paste codes like 20261104143015.0Z 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 row by hand. Other endings and offsets are never guessed or converted.
Microsoft's help: DATE function
OTHER ROUTES YOU MIGHT LIKE

Read UTC times with two-digit years
261104143015Z → November 4, 2026 2:30:15 PM
Get the template →
Read long Unix codes, even before 1970
Unix microseconds -1361957384876544 → 11/4/1926 2:30:15.123 PM
Get the template →
Combine seconds and nanos into UTC
1793802615 s, 500000000 ns → 11/4/2026 14:30:15.500
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →