Skip to content

Instantly share code, notes, and snippets.

@anthonylrivera

anthonylrivera/timestamp2date-excel.txt

Created January 25, 2018 19:58
Show Gist options
  • Save anthonylrivera/c6a8fde09e460fb9bcb4bcbdbb1cdab2 to your computer and use it in GitHub Desktop.
Save anthonylrivera/c6a8fde09e460fb9bcb4bcbdbb1cdab2 to your computer and use it in GitHub Desktop.
Download ZIP
Formula to convert a UNIX timestamp (in cell C2) to Excel date format.
Raw
timestamp2date-excel.txt
=(C2/86400/1000)+25569
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment