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)

 

Matt Reid

Lead Software Architect. Java/Node enthusiast, badminton lover, foodie.

drei01 Matthew_Reid


Published