Excel - Convert Unix Timestamp to Date

Tags Excel HowTo

Issue/Question

  • How do I convert Unix timestamps to dates in Excel?

Environment

  • Excel 2016

Resolution

  1. Add a new column for the date
  2. Set the cell formatting in the new column to "Date"
  3. Enter the following formula in the new column: =A1/(24*60*60) + DATE(1970,1,1) 

Details

Article ID: 67656
Created
Mon 11/26/18 11:12 AM
Modified
Thu 6/25/20 4:26 PM