Read /Date(…)/ values with a time zone
Turn /Date(1793802615000+0100)/ into the UTC time, without adding the +0100.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | TEXTBEFORE(TEXTAFTER( … )) | Takes what is between /Date( and )/. LET calls it s. | "1793802615000+0100" |
| 2 | IF(LEFT(s,1)="-", … ) | Drops a leading minus. LET calls it u. | "1793802615000+0100" |
| 3 | TEXTBEFORE(SUBSTITUTE( … )) | Keeps the digits before any + or -. LET calls it e. | "1793802615000" |
| 4 | DATE(1970,1,1)+ … /86400000 | Counts milliseconds from January 1, 1970, back for a minus. | November 4, 2026 2:30:15 PM |
| 5 | LET( … ) | Names each step so the formula reads in order. | November 4, 2026 2:30:15 PM |
The +0100 on the end is only a note. The number is already UTC, so it isn't added.
=LET(s,TEXTBEFORE(TEXTAFTER(A8,"/Date("),")/"),u,IF(LEFT(s,1)="-",MID(s,2,99),s),e,TEXTBEFORE(SUBSTITUTE(u,"-","+")&"+","+"),DATE(1970,1,1)+IF(LEFT(s,1)="-",-1,1)*VALUE(e)/86400000)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 dates. Paste values like /Date(1793802615000+0100)/ 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
The results are UTC. Don't add the time zone on the end again; it's already counted.
Microsoft's help: TEXTAFTER function
OTHER ROUTES YOU MIGHT LIKE

Read GMT-0500 timestamps as UTC
Wed Nov 04 2026 14:30:15 GMT-0500 (EST) → 11/4/2026 19:30:15
Get the template →
Convert an email date to UTC
Wed, 04-Nov-2026 14:30:15 +0530 → November 4, 2026 9:00:15 AM
Get the template →
Read minute-offset timestamps as UTC
20261104143015.123456+330 → 11/4/2026 9:00:15.123 AM
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →