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 vote317 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote269 views1 answer
Reset border color textbox vba
VBA
1 vote269 views1 answer
Excel vba force recalculation
VBA
0 vote272 views1 answer
Excel vba delete folder
VBA
0 vote288 views2 answers
Get unique random number in vb.net
VBA
5 votes347 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote267 views1 answer
Vbscript Trim
VBA
0 vote291 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote282 views1 answer
Selecttoken em vbnet e json
VBA
0 vote336 views2 answers
Excel vba store array and write to sheet
VBA