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

Source: academy.excelhero.com

Similar codes

1 vote276 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
6 votes320 views1 answer
Excel vba isalpha
VBA
1 vote291 views1 answer
Excel vba saveas force overwrite
VBA
0 vote311 views1 answer
Vba boolean to string
VBA
1 vote236 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote308 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote276 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote286 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote285 views1 answer
Change form background image vb
VBA
0 vote264 views1 answer
Excel vba disable copy paste
VBA