Excel - Convert Unix Timestamp to Date

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)