Print
Print:
Body
Details
Excel - Convert Unix Timestamp to Date
Body
Issue/Question
How do I convert Unix timestamps to dates in Excel?
Environment
Excel 2016
Resolution
Add a new column for the date
Set the cell formatting in the new column to "Date"
Enter the following formula in the new column: =A1/(24*60*60) + DATE(1970,1,1)
Details
Details
Article ID:
67656
Created
Mon 11/26/18 2:12 PM
Modified
Thu 6/25/20 7:26 PM