回答:如果不指定某个日期就使用 DATEDELTA(TODAY(),-1*WEEKDAY(TODAY())-7)实时模式:求上周周一时间:DATEDELTA(DATE(2020,07,28),-1*WEEKDAY(DATE(2020,07,28))-7)求上周周末时间:DATEDELTA(DATE(2020,07,28),-1*WEEKDAY(DATE(2020,07,28)))抽取模式:求上周周一时间:dateinweek(DATEDELTA(DATE(2020,7,28),-7),1)求上周周末时间:dateinweek(DATEDELTA(DATE(2020,7,28),-7),7)