How to convert dates in Excel to Unix Timestamp Dates

Описание

A simple guide on how to convert dates in Excel to a Unix Timestamp Format. The Unix count starts at the 'Unix Epoch' on January 1st, 1970 at UTC. Therefore, the Unix timestamp is merely the number of seconds between a particular date and the Unix Epoch.

On another note - to convert Unix timestamps back to an Excel Date format
Simply take your Unix time and the divide by 86400 then add 25569
ie... =(1538352000/86400)+25569

Here is a great resource: https://exceljet.net/formula/convert-unix-time-stamp-to-excel-date