DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Excel Formulas to Convert Unix Time Stamp into Excel Date!!

So far, we have learned the simple formulas to convert the Excel date to Unix time in Excel. Likewise, here we will show the simple formula to convert the Unix time stamp into the Excel date. Let’s get into this article!!

Unix time is also known as Epoch Time or POSIX time or Unix timestamp. The Unix time tracks the time as a running count of seconds , and it begins from January 1st, 1970. It is mostly used in operating systems or file formats. Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Convert Unix time to Excel date
Convert Unix time to Excel date

General Formula:

  • Use the below formula to convert a Unix timestamp to Excel’s date format.

=(A1/86400)+DATE(1970,1,1)

Syntax Explanations:

  • DATE – In Excel, the DATE function will combine three different values and returns them as a date.
  • A1 – It represents the input time on your worksheet.
  • Plus operator (+) – This symbol is used to add the values.
  • Division (/) – It is used for dividing values or numbers.
  • Comma symbol (,) – It is a separator that helps to separate a list of values.
  • Parenthesis () – The main purpose of this symbol is to group the elements.

Example:

Refer to the below example image.

  • First, we will enter the input as a Unix timestamp in Column B.
  • Now we are going to convert them into original Excel date.

Input Range
Input Range

  • Select any cell and type the above-given formula.

Enter the formula
Enter the formula

  • Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Result
Result

Conclusion:

Hope you like this article on how to convert Unix time into Excel date. If you have any doubt regarding this article or have any other questions related to Excel, let me know in the comments section below. I reply to queries frequently!!

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Read Also:

Top comments (0)