Google Sheets Apps Scripts: Custom Function Convert Unix Timestamp to Date

July 16, 2019

At Google Sheets, click Tools -> Script Editor.

Edit the script and click Save.

function TIMESTAMP_TO_DATE(value) {
  return new Date(value * 1000);

Now you can use this custom function / formula in Google Sheets.



This work is licensed under a
Creative Commons Attribution-NonCommercial 4.0 International License.