LET(A, RANGE(date(year(format(CONCATENATE($YF, "-", day(today())), "yyyy-MM-dd")), 1, 1), date(year(format(CONCATENATE($YF, "-", day(today())), "yyyy-MM-dd")), 12, 31)), IF(weekday(greparray(A, AND(MONTH(item) = A7, weekday(item) = A9))) < weekday(date(year(format(CONCATENATE($YF, "-", day(today())), "yyyy-MM-dd")), A7, 1)), greparray(add2array(A, ""), OR(item = "", AND(MONTH(item) = A7, weekday(item) = A9))), greparray(A, AND(MONTH(item) = A7, weekday(item) = A9))))
8.0日期和星期是正确对上的，10就出现图片的情况。错位了，这是什么问题呢？ |
1min目标场景问卷
立即参与
