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)