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

Add Own solution

Log in, to leave a comment

Are there any code examples left?

Find Add Code snippet

New code examples in category VBA

VBA 2022-03-27 20:55:02 excel vba check if all substrings in list are in string
VBA 2022-03-27 20:40:39 excel vba set cell value to empty
VBA 2022-03-27 17:05:52 vba simple quote
VBA 2022-03-27 14:30:19 textbox find and replace vb
VBA 2022-03-27 09:10:21 nested if else in vb.net
VBA 2022-03-27 09:10:09 excel vba string to bits
VBA 2022-03-25 02:00:15 vba verticalalignment
VBA 2022-03-24 12:20:06 Excel web scraping
VBA 2022-03-24 10:11:00 excel vba BitToLong
VBA 2022-03-21 18:00:05 excel vba save file txt

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

convert unix time to date in sheets unix time to date excel TRANSFORM unix timestamp into date time excel unix time to datetime excel unix timestamp to excel date how to convert unix timestamp to date in excel excel turn unix timestamp into date Convert Unix time stamp to Excel date. excel get unix timestamp unixtimestamp to date time in excel convert unix timestamp in sheets transform unix timestamp to date excel excel unix time to time excel unix to date time excel UTC to UNIX timestamp how to convert unix timestamp to minutes in excel convert excel datetime to unix timestamp convert unix timestamp milliseconds to date excel convert unix timestamp excel unix timestamp to date excel italiano unix timestamp to date excel unix timestamp excel date time how to converts timestamp in unix to date make unix timestamp from date excel excel convert unix timestamp to date time how to convert 13 digit unix timestamp to date in excel excel get date time from unix timestamp excel convert unix timestamp to date excel format unix timestamp to date convert military time to unix timestamp excel excel datetime to unix formula to convert unix timestamp to date convert unix timestamp to datetime in excel conver datetime to UNIX in Excel excel convert a unix timestamp convert timestamp to unix time in EXCEL excel unix to date convert date string to unix timestamp excel convert date string to unix timestamp sheets excel formula to convert unix timestamp to date and time convert unix to timestamp excel excel convert from unix timestamp unix to time excel timestamp format convert column of unix timestamp to date convert datetime.datetime to unix timestamp excel timestamp format convert to unix convert date to unix timestamp excel unix timestamp excel excel convert unix timestamp excel unix timestamp to milliseconds excel date time and seconds to unix excel convert data and time to unix excel unix timestamp to date excel unix timestamp to datetime excel unix timestamp excel convert unix timestamp to date and time convert unix timestamp on excel convert unix date in excel how to convert unix timestamp to date excel convert excel date to unix timestamp timestamp to datetime excel formula excel timestamp to date convert unix timestamp to datetime date to unix timestamp sql excel date time to timestamp unix timestamp to date moment typescript convert date to unix timestamp excel formula to create unix timestamp sql unix timestamp to date excel convert unix time to datetime convert date to unix timestamp online unix timestamp to date convert date to unix timestamp date to unix timestamp excel convert date to timestamp excel convert timestamp to date excel convert date time to unix timestamp excel timestamp to epoch excel epoch to date excel unix epoch time converter excel convert date time to epoch convert datetime to epoch in excel how to convert timestam to UTC in excel convert datetime to unix timestamp excel timestamp to date excel excel date to epoch excel date to unix timestamp

Made with love

Welcome Back!

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Create a Free Account

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Creating a new code example