let range = SpreadsheetApp.getActiveSpreadsheet().getSheetByName().getDataRange();
let values = range.getValues();
const formatDate = (date) => Utilities.formatDate(date, "GMT+3", "dd.MM.yyyy");
let now = formatDate(new Date());
let newValues = values.map(row=>{
let [date, ...rest] = row;
let formattedDate = formatDate(date);
return now===formattedDate?[now, ...rest]:row;
});
range.setValues(newValues);