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).
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
Q: Is this seconds or milliseconds? A: This function expects seconds. Divide milliseconds by 1000 first.
Q: What timezone is used? A: Unix timestamps are UTC. The result may need timezone adjustment.
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?