切换日期和月份google工作表

=TEXT(DATE(YEAR(A1), DAY(A1), MONTH(A1)), "DD/MM/YYYY")

=TEXT(DATE(VALUE(MID(A1, 1, 4)), VALUE(MID(A1, 9, 2)), VALUE(MID(A1, 6, 2))), "DD/MM/YYYY")

function switchDateAndMonth(date) {
  var d = new Date(date);
  var day = d.getDate();
  var month = d.getMonth() + 1; // getMonth() returns 0-11, so add 1
  var year = d.getFullYear();
  
  // Create new date with switched day and month
  var newDate = new Date(year, day - 1, month); // day - 1 because setMonth() expects 0-11
  return Utilities.formatDate(newDate, Session.getScriptTimeZone(), "dd/MM/yyyy");
}

=SWITCHDATEANDMONTH(A1)

function switchDateAndMonthBatch() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getRange("A1:A10"); // 修改为您的范围
  var values = range.getValues();
  
  for (var i = 0; i < values.length; i++) {
    var date = values[i][0];
    if (date instanceof Date) {
      var d = new Date(date);
      var day = d.getDate();
      var month = d.getMonth() + 1;
      var year = d.getFullYear();
      var newDate = new Date(year, day - 1, month);
      values[i][0] = Utilities.formatDate(newDate, Session.getScriptTimeZone(), "dd/MM/yyyy");
    }
  }
  
  range.setValues(values);
}