Unix DateTime Number

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)

Author: ANmar