我现在有一个业务逻辑,周二12点过后填写的数据是当周的数据,12前填写的数据属于上周,标题日期显示周一至周五例如2021-08-30~~2021-09-03,求求大佬帮帮忙
IF(AND(WEEKDAY(TODAY())<=2,HOUR(NOW())<=12),
DATEDELTA(DATEINWEEK(today(),1),-7),
DATEINWEEK(today(),1))
WEEKDAY(today()) 判断今天周几
hour(right(now(),8)) 判断现在几点
如果上述条件不满足周二 12 点 ,就把今天的日期向前推,否则就向后推