How to convert the unix date format to excel date format

Hi Concern,

I have attached the excel files for converting date format from Unix to Excel date format.

and tried the following formulas

=(A1-DATE(1970,1,1))*86400
=(((A1/60)/60)/24)+DATE(1970,1,1)+(-5/24)
=CELL/(60*60*24)+"1/1/1970"

For Instance, having unix date in below format

1464500377000 in General format showing as 1.4645E+12

when i'm using above formula's getting

=(A1-DATE(1970,1,1))*86400 >>>> 1.26533E+17 and tried to change the date format showing ##########

=(((A1/60)/60)/24)+DATE(1970,1,1)+(-5/24) >>>>> 16975804.64 and tried to change the date format showing ##########


=CELL/(60*60*24)+"1/1/1970" >>>>>> 16975804.84 and tried to change the date format showing ##########



Kindly assist me to convert the date format from unix to excel

Regards,
Siva

Have a look at this page.
http://spreadsheetpage.com/index.php...ix_timestamps/

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".