本周的公式CONCATENATE("本周完成情况:",DATEINWEEK(TODAY(),1),"至",DATEINWEEK(TODAY(),-1))那么上周的,或者下周的该怎么写?
CONCATENATE("上周完成情况:",DATEINWEEK(TODAY()-7,1),"至",DATEINWEEK(TODAY()-7,-1))
CONCATENATE("下周完成情况:",DATEINWEEK(TODAY()+7,1),"至",DATEINWEEK(TODAY()+7,-1))
DATEDELTA(DATEINWEEK(TODAY(),1),-7) 参考上周一
"本周:"+today()+""+"上周:"+(today()-7)
你好,测试了没有是你要的结果吗?