Unix DateTime Number
January 6, 2023
Convert Date/time number from regular number to Unix DateTime Number.
A project I worked on, needed to grab info from Yahoo! finance passing to it the datetime of certain period.
This function was part of the solution to convert a date as we human use it to Unix datetime number for the website to populate finance info of that period.
The final formula is
=(B5246060)-(DATE(1970,1,1)246060)
About The Author
ANmar
An Excel-Passionate user, developer and teacher Love finding new ways to solve daily issues and enhances to regular users, then teach that