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) 

Print Article