Vba 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

0 vote362 views1 answer
Excel named range sum
VBA
0 vote345 views1 answer
VBA Sleep Snippet
VBA
0 vote349 views1 answer
Afficher un message d'erreur vba
VBA
-1 vote321 views2 answers
How close excel through visual basic
VBA
1 vote330 views1 answer
How to open cmd with vbd
VBA
1 vote342 views1 answer
Excel vba saveas force overwrite
VBA
0 vote310 views1 answer
How to make a if statement with vbs
VBA
0 vote329 views1 answer
Excel vba range contains
VBA
5 votes385 views1 answer
Xlvba double quotes in string literal
VBA
0 vote347 views1 answer
Excel vba send HTTP POST to server
VBA