In this article, I reveal step by step instructions to convert a 10 digit number unix timestamp into a date in Excel. This is particularly useful to Joomla users as Joomla stores and exports date as Unix Timestamps.

    Unix timestamp is defined as the total number of seconds since midnight (GMT time) on January 1, 1970 - also known as the Unix epoch.

    Published in Microsoft Excel