Read UTC times with two-digit years
Turn 261104143015Z into a real date and time. 49 means 2049, 50 means 1950.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | AND(LEN(A8)=13,RIGHT(A8,1)="Z") | Checks for 13 characters ending in Z. | TRUE |
| 2 | IF(VALUE(LEFT(A8,2))>=50, … ) | Picks 1900 for years 50 to 99, otherwise 2000. | 2000 |
| 3 | DATE( … ) | Adds the two-digit year, then the month and day. | November 4, 2026 |
| 4 | TIME( … ) | Adds the hour, minutes and seconds. | November 4, 2026 2:30:15 PM |
| 5 | IF( … ) | Shows the date and time, or else the Review message. | November 4, 2026 2:30:15 PM |
It works from the inside out: part 2 picks the century, then DATE adds the year to it. The time stays in UTC.
=IF(AND(LEN(A8)=13,RIGHT(A8,1)="Z"),DATE(IF(VALUE(LEFT(A8,2))>=50,1900,2000)+VALUE(LEFT(A8,2)),MID(A8,3,2),MID(A8,5,2))+TIME(MID(A8,7,2),MID(A8,9,2),MID(A8,11,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 261104143015Z 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 this only for certificate times. Other two-digit years, like birthdays, need their own century rule.
Microsoft's help: DATE function
OTHER ROUTES YOU MIGHT LIKE

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 →
Combine seconds and nanos as days
178215 s, 500000000 ns → 2.062679 days
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →