前7天
方法1,
RANGE(DATEDELTA(dateInWeek($qs, 1), -(WEEK(dateInWeek($qs, 1)) - $rq+1) * 7), DATEDELTA(dateInWeek($qs, -1), -(WEEK(dateInWeek($qs, 1)) - $rq+1) * 7))
当前日期7天
方法2
range(dateinweek($p1,1),dateinweek($p1,-1))
前7天
方法1,
RANGE(DATEDELTA(dateInWeek($qs, 1), -(WEEK(dateInWeek($qs, 1)) - $rq+1) * 7), DATEDELTA(dateInWeek($qs, -1), -(WEEK(dateInWeek($qs, 1)) - $rq+1) * 7))
当前日期7天
方法2
range(dateinweek($p1,1),dateinweek($p1,-1))