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

0 vote189 views1 answer
How to enter Vbox manage commands
VBA
3 votes157 views1 answer
Vba folderexists
VBA
1 vote159 views1 answer
What does vbs stand for
VBA
0 vote167 views1 answer
Search in richtextbox vb.net
VBA
1 vote172 views1 answer
Excel vba array remove first
VBA
0 vote171 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
0 vote153 views1 answer
How to set location and size of new from vb
VBA
0 vote174 views1 answer
Vba keep command window open
VBA
1 vote163 views1 answer
Vba date to unix timestamp
VBA
3 votes162 views1 answer
Excel vba last row in range
VBA