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

Get FREE Advanced Excel Exercises with Solutions!

Epoch time is the beginning point (date and time) from which computers measure their system time. For example, the epoch time in UNIX and POSIX-based operating systems is 00:00:00 UTC on Thursday, January 1, 1970. Sometimes, we face an epoch time dataset that is simply a tally of seconds counting from Unix Epoch time. However, we can not grasp just numbers since we utilize date, month, and year to count time. So, weâ€™re going to convert epoch time to date excel

## Convert Epoch Time to Date in Excel: 2 Simple Methods

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

### 1. Using DATE Function and Format Cells Tool

Weâ€™ll first convert Unix timestamps to serial numbers using a formula with the DATE function, then use the date format to convert them to Excel dates.

ðŸ“Œ Steps:

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

• Now, drag the Fill handle to fill the following cells in that column.

• After applying the formula, we will just copy the column to the adjacent column by Ctrl+C and Paste the Values into the Date columns.

• At this moment, we will select the serial no. and Format Cellsâ€¦ to convert those numbers to date.

• Meanwhile, the Format Cells pop-up box will appear and we will select Date from Category, then 14-Mar-2012 from Type, and after that just click Ok.

• Subsequently, 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

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

The TEXT function may also be used together with the DATE function to convert Unix timestamp information to Excel dates.

ðŸ“Œ Steps:

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

• Drag the Fill handle and we will fill up the rest of the cells.

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

## Conclusion

Follow these steps and stages to convert epoch time to date excel. You are welcome to download the workbook and use it for your own practice. If you have any questions, concerns, or suggestions, please leave them in the comments section.

## Related Articles

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

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
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