[已解决]如何以"周数"自动计算起止日期~~~

万事亨通

如何以"周数"自动计算起止日期~~~

最佳答案

月排行榜 / 总排行榜

cutecpu

2021-4-9 19:37

=TEXT("1/1"-WEEKDAY("1/1",2)+7*B3-7,"m月d日--")&TEXT("1/1"-WEEKDAY("1/1",2)+7*B3-1,"m月d日")

祝順心，南無阿彌陀佛！

跳转到最佳答案楼层

cutecpu

=TEXT("1/1"-WEEKDAY("1/1",2)+7*B3-7,"m月d日--")&TEXT("1/1"-WEEKDAY("1/1",2)+7*B3-1,"m月d日")

祝順心，南無阿彌陀佛！

万事亨通

cutecpu 发表于 2021-4-9 19:37
=TEXT("1/1"-WEEKDAY("1/1",2)+7*B3-7,"m月d日--")&TEXT("1/1"-WEEKDAY("1/1",2)+7*B3-1,"m月d日")

祝順 ...

谢谢~~