Excel date to Unix timestamp

by

Non of these worked for me… when I converted the timestamp back it’s 4 years off.

This worked perfectly: =(A2-DATE(1970,1,1))*86400

Credit goes to: Filip Czaja http://fczaja.blogspot.ca

Original Post: http://fczaja.blogspot.ca/2011/06/convert-excel-date-into-timestamp.html

More Related Contents:

  1. Format Cell Contents
  2. Excel formula checklist in employees
  3. How do I put double quotes in a string in vba?
  4. Stop Excel from automatically converting certain text values to dates
  5. How can I URL encode a string in Excel VBA?
  6. Excel’s fullname property with OneDrive
  7. How to insert an embedded picture?
  8. Excel VLOOKUP where the key is not in the first column
  9. Excel Formula for Inventory
  10. Obtain attribute names from XML using VBA
  11. Using UNIQUE with non-adjecent columns on different sheets
  12. Paste Excel range in Outlook
  13. Concatenate top row cells if column below has 1
  14. Return RGB values from Range.Interior.Color (or any other Color Property)
  15. Run-time error ‘1004’ : Method ‘Range’ of object’_Global’ failed
  16. “Can’t find Project or Library” for standard VBA functions
  17. How do I issue an HTTP GET from Excel VBA for Mac
  18. Copy sheet and get resulting sheet object?
  19. Excel: match two columns and output third … AND… there are multiple instances in each column
  20. Export chart as image – with click of a button
  21. Error13 in Excel VBA in data file
  22. Importing CSV with line breaks in Excel 2007
  23. Excel VBA to match and line up rows
  24. Change font color for a part of text in cell
  25. Create a new object using the text name of the class
  26. Excel cell from which a Function is called [duplicate]
  27. How to extract text within a string of text
  28. GET pictures from a url and then rename the picture
  29. Excel: Find min/max values in a column among those matched from another column
  30. Access files with long paths (over 260)

Leave a Comment