excel周一至周五正常显示各自对应的日期,周六和周日都显示为周五所对应的日期

2025-06-22 22:37:58
推荐回答(2个)
回答1:

=TEXT(RIGHT(A1,LEN(A1)-FIND("-",A1))+1,"m月d日")&"-"&TEXT(RIGHT(A1,LEN(A1)-FIND("-",A1))+7,"m月d日")

回答2:

=TODAY()-(MAX(WEEKDAY(TODAY(),3),4)-4)

=A1-(MAX(WEEKDAY(A1,3),4)-4)