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 vote131 views1 answer
Excel vba protect sheet
VBA
0 vote118 views1 answer
Excel protect cells with formulas
VBA
0 vote136 views1 answer
Vba change active sheet
VBA
5 votes107 views1 answer
Vba array worksheet.index
VBA
0 vote134 views1 answer
Excel vba urlmon
VBA
0 vote159 views1 answer
Find control with name vb
VBA
1 vote118 views1 answer
Vba compile error object required
VBA
1 vote124 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote129 views1 answer
VB Error Code BC30201
VBA
13 votes258 views2 answers
Vba write text file
VBA