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;

Tags:

Misc Example