Just a quick one for converting cells in epoch format to dates, I am using this for data pullled from mongodb.
=ID_OF_CELL/86400000+DATE(1970,1,1)