neufeldtech

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  // Or DocumentApp or FormApp.
  ui.createMenu('Extra Format')
      .addItem('Horizontal', 'formatHorizontal')
      .addItem('Vertical', 'formatVertical')
      .addToUi();
}
function formatHorizontal() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();

neufeldtech

// Convert Excel dates into JS date objects
//
// @param excelDate {Number}
// @return {Date}

function getJsDateFromExcel(excelDate) {

  // JavaScript dates can be constructed by passing milliseconds
  // since the Unix epoch (January 1, 1970) example: new Date(12312512312);