国内| 当前日期| today()本周第一天| dateInWeek(TODAY(),1)本周最后一天| dateInWeek(TODAY(),-1)上周第一天| dateInWeek(DATEDELTA(TODAY(),-7),1)上周最后一天| dateInWeek(DATEDELTA(TODAY(),-7),-1)下周第一天| dateInWeek(DATEDELTA(TODAY(),7),1)下周最后一天| dateInWeek(DATEDELTA(TODAY(),7),-1)国外注:TODAY()+1:在国外,周末是个特例,它相当于国内下周的第一天即相对国内来说,国外整个一周的时间都向后推移一天,例如:国内的周六相当于国外的周日,国内的周日相当于国外下周的周一 。| 本周第一天| dateInWeek(TODAY()+1,1)-1本周最后一天| dateInWeek(TODAY()+1,-1)-1上周第一天| dateInWeek(TODAY()+1,1)-8上周最后一天| dateInWeek(TODAY()+1,-1)-8下周第一天| dateInWeek(TODAY()+1,1)+6下周最后一天| dateInWeek(TODAY()+1,-1)+6