发布网友 发布时间:2022-05-24 21:43
共3个回答
热心网友 时间:2023-11-04 12:04
公式如下:
=IF(WEEKDAY(TODAY(),2)>5,TODAY()+8-WEEKDAY(TODAY(),2),TODAY())
如图所示:
热心网友 时间:2023-11-04 12:04
=IF(WEEKDAY(TODAY(),2)>5,TODAY()+8-WEEKDAY(TODAY(),2),TODAY())热心网友 时间:2023-11-04 12:05
=if(weekday(today(),2)<6,today(),today()+8-weekday(today(),2)