# Convert Epoch Time to Date in Excel (2 Easy Methods)

In cells B5:B16, we have a range of Unix timestamps to transform to dates.

### Method 1 – Using the DATE Function and the Format Cells Tool

Steps:

• Enter the following formula into cell C5 and hit Enter.
`=(((B5/60)/60)/24)+DATE(1970,1,1)`

• Drag the Fill handle to fill the following cells in that column.

• Copy the column to the adjacent column with Ctrl + C, then Paste the Values into the Date columns.

• Select the column, right-click, and pick Format Cellsâ€¦.

• The Format Cells pop-up box will appear. Select Date from Category.
• Pick 14-Mar-2012 from Type.Â You can pick another date format if you want.
• Click OK.

• This data set in the below image is a representation of the conversion of the epoch time to date.

Read More: How to Convert Time to Decimal in Excel

### Method 2 – Combine DATE & TEXT Functions to Convert Epoch Time to Date

Steps:

• Click on cell C5 and enter the following formula:
`=TEXT((B5/86400)+DATE(1970,1,1),"m/d/yyyy")`

• Drag the Fill handle to fill up the rest of the cells.

Read More: How to Convert Time to Number in ExcelÂ

## Related Articles

<< Go Back to Time Conversion | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Al Ikram Amit

Al Ikram Amit, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a key Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Amit not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently delivering exceptional, high-quality content that adds significant... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF