答案1
与此类似的东西会起作用
=IF(AND(WEEKNUM(TODAY(),1)-WEEKNUM(A5,1)<=6,WEEKNUM(TODAY(),1)-WEEKNUM(A5,1)>0),"yes","no")
它使用周数返回日期所在年份的周数。但是,如果您从 12 月到 1 月,则此方法无效。这样,您只需要计算天数即可。
与此类似的东西会起作用
=IF(AND(WEEKNUM(TODAY(),1)-WEEKNUM(A5,1)<=6,WEEKNUM(TODAY(),1)-WEEKNUM(A5,1)>0),"yes","no")
它使用周数返回日期所在年份的周数。但是,如果您从 12 月到 1 月,则此方法无效。这样,您只需要计算天数即可。