Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
EPOCHTODATE
EPOCHTODATE is a Google Sheets-specific function that transforms a Unix epoch integer (seconds since 1970-01-01 00:00:00 UTC) into a Sheets serial date-time value, with an optional second argument specifying the unit (1=seconds, 2=milliseconds, 3=microseconds). Use it to work with API timestamps, log data, or any system that exports Unix timestamps.
Excel
=((A2/86400)+DATE(1970,1,1))Google Sheets
=EPOCHTODATE(A2,1)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| UnixTimestamp | DateTimeValue |
| 1704067200 | |
| 1711929600 | |
| 1719792000 | |
| 1727654400 |
=((A2/86400)+DATE(1970,1,1))→45292
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Place Unix epoch values (in seconds) in column A.
- 2In Google Sheets type =EPOCHTODATE(A2,1) to convert seconds, or =EPOCHTODATE(A2,2) for milliseconds.
- 3Format the result cell as Date/Time to display it readably; in Excel use the workaround formula instead.
Need a version for your data?
Try: “Convert Unix timestamps from my API logs into readable dates in Google Sheets”