Convert Unix Time stamp to Excel date
Converts a Unix timestamp (seconds since January 1, 1970 UTC) to an Excel serial date that can be formatted and used in date calculations.
Parameters
| Parameter | Description | Example |
|---|---|---|
| UnixTime | Seconds since epoch | 1704067200 |
Unix Timestamp
Unix time (also known as POSIX time or epoch time) is a system for tracking time as a running total of seconds since January 1, 1970 (midnight UTC).
Syntax
=UnixTimestampToDateTime(UnixTime)Parameters
unixTimenumberRequired
Unix timestamp (seconds since Jan 1, 1970)
Returns
date
Excel date/time value
Examples
When to Use
- Converting API timestamps to readable dates
- Working with financial data that uses Unix time
- Data transformation from external sources
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need date to Unix | DateTimeToUnixTimestamp() |
Common Issues & FAQ
Is this seconds or milliseconds?
This function expects seconds. Divide milliseconds by 1000 first.
What timezone is used?
Unix timestamps are UTC. The result may need timezone adjustment.
Related Formulas
More MarketXLS Date Functions formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?