Get new Date

A simple function to get a formatted date instead of a timestamp in Apps Script. Get the timezone of the sheet so a user doesn't have to edit anything other than the timezone of the sheet and apps script.

function newDate(){
  return Utilities.formatDate(new Date(),
  SpreadsheetApp.getActiveSpreadsheet().getSpreadsheetTimeZone(),
  "MM/dd/yyyy")
}