excel unix timestamp to date code example
Example 1: excel date to unix timestamp
'VBA functions to convert between Excel and Unix date-times.
'These work on Windows and optionally the Mac:
Function UnixDateTime#(ExcelDateTime As Date, Optional Mac As Boolean)
Dim OSOffset: OSOffset = IIf(Mac, 24107, 25569)
UnixDateTime = (ExcelDateTime - OSOffset) * 86400
End Function
Function ExcelDateTime(UnixDateTime#, Optional Mac As Boolean) As Date
Dim OSOffset: OSOffset = IIf(Mac, 24107, 25569)
ExcelDateTime = (UnixDateTime / 86400) + OSOffset
End Function
Example 2: transform unix timestamp in date
//Our date string. The format is Y-m-d H:i:s
$date = '2019-04-01 10:32:00';
//Convert it into a Unix timestamp using strtotime.
$timestamp = strtotime($date);
//Print it out.
echo $timestamp;