Excel VBA: Convert a date string to a Unix timestamp

by

Date to timestamp:

Public Function toUnix(dt) As Long
    toUnix = DateDiff("s", "1/1/1970", dt)
End Function

Timestamp to date:

Public Function fromUnix(ts) As Date
    fromUnix = DateAdd("s", ts, "1/1/1970")
End Function

More Related Contents:

  1. Autofilter with column formatted as date
  2. Changing the date format to yyyy-mm-dd
  3. Convert month name into number
  4. How to color all the rows based on the cell values
  5. Excel – opening file stuck on 100%, until VBA code finishes
  6. Using a UDF in Excel to update the worksheet
  7. VBA check if file exists
  8. Excel’s fullname property with OneDrive
  9. How to insert an embedded picture?
  10. How to call a macro from a button and pass arguments
  11. Copy Excel range as Picture to Outlook
  12. Obtain attribute names from XML using VBA
  13. Paste Excel range in Outlook
  14. Return RGB values from Range.Interior.Color (or any other Color Property)
  15. VBa conditional delete loop not working
  16. Translate text using vba
  17. Run-time error ‘1004’ : Method ‘Range’ of object’_Global’ failed
  18. “Can’t find Project or Library” for standard VBA functions
  19. How do I issue an HTTP GET from Excel VBA for Mac
  20. Update excel sheet based on outlook mail [closed]
  21. Copy sheet and get resulting sheet object?
  22. In Excel, can I use a hyperlink to run vba macro?
  23. Select Newest Record and Create New Table of Unique Values in Excel
  24. Are ActiveX Controls Disabled?
  25. Excel Date Conversion from yyyymmdd to mm/dd/yyyy
  26. Best way to protect Excel VBA code? [closed]
  27. VBA copy rows that meet criteria to another sheet
  28. VBA Dialog box to select range in different workbook
  29. Function Overloading and UDF in Excel VBA
  30. VBA Excel simple Error Handling

Leave a Comment