Google Apps Script to hide columns which include the date until yesterday.

hideUntilYesterday.gs

function hideUntilYesterday() {
  const spreadSheetId = 'spreadSheetId';
  const spreadSheet = SpreadsheetApp.openById(spreadSheetId);
  const yesterdayTime = Date.now() - (24 * 60 * 60 * 1000);

  for (const sheet of spreadSheet.getSheets()) {
    const lastColumn = sheet.getLastColumn();

    let column = 2;
    while (column <= lastColumn) {
      const value = sheet.getRange(2, column).getValue().toString();
      const dateTime = Date.parse(value);

      if　(dateTime < yesterdayTime) {
        sheet.hideColumn(sheet.getRange(1, column));
      }

      column++;
    }
  }
}