Function getPreviousWeekRange

scripts/sendWeeklyExcelSheet.mjs:13–25

()

}

function getPreviousWeekRange() {
  let today = new Date();
  let endDate = new Date(today);

  let startDate = new Date(today);
  startDate.setDate(today.getDate() - 7);

  function fmt(d) {
    return d.toISOString().split('T')[0];
  }

  return {startDate: fmt(startDate), endDate: fmt(endDate)};
}

function formatDateLabel(dateStr) {
  let d = new Date(dateStr + 'T12:00:00Z');