function formatDateColumnAllSheets() {
const sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
sheets.forEach(sheet => {
const range = sheet.getRange("A13:A");
const values = range.getValues();
for (let i = 0; i < values.length; i++) {
if (typeof values[i][0] === "string" && values[i][0].includes("-")) {
const parts = values[i][0].split("-");
if (parts.length === 3) {
const year = Number(parts[0]);
const month = Number(parts[1]) - 1;
const day = Number(parts[2]);
values[i][0] = new Date(year, month, day);
}
}
}
range.setValues(values);
range.setNumberFormat("dd-MM-yyyy");
});
}
Code định dạng dd/mm/yyyy