Read a /Date(…)/ value as a timestamp
Turn /Date(1793802615000)/ into the UTC date and time, with or without backslashes.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | DATE(1970,1,1) | The day the count of milliseconds starts from. | January 1, 1970 |
| 2 | SUBSTITUTE(A8,CHAR(92),"") | Removes any backslashes, so \/Date( becomes /Date(. | "/Date(1793802615000)/" |
| 3 | TEXTBEFORE(TEXTAFTER( … )) | Takes the digits between /Date( and )/. | "1793802615000" |
| 4 | /86400000 | Turns milliseconds into days: 86,400,000 in a day. | November 4, 2026 2:30:15 PM |
Parts 2 and 3 work from the inside out. Excel then adds the days to January 1, 1970.
=DATE(1970,1,1)+TEXTBEFORE(TEXTAFTER(SUBSTITUTE(A8,CHAR(92),""),"/Date("),")/")/86400000How 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)/ 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
Values with a time zone on the end, like /Date(1793802615000+0100)/, turn amber. This reads UTC values only.
Microsoft's help: TEXTBEFORE function
OTHER ROUTES YOU MIGHT LIKE

Read seconds since 1960 as timestamps
Seconds since 1960 2109421815 → November 4, 2026 2:30:15 PM
Get the template →
Read a timestamp with a century prefix
04-NOV-26 02.30.15.123456 PM + 20 → 11/4/2026 14:30:15.123
Get the template →
Keep missing timestamp markers blank
NULL → blank; 2026-11-04T14:30:15 → November 4, 2026 2:30:15 PM
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →