Excel表如何设置日期自动跳过星期天，如A1为3月10日是星期四，B1按A1自动加四天，即为16

发布网友 发布时间：2022-05-01 15:48

我来回答

共3个回答

热心网友 时间：2023-10-22 13:43

=A1+IF(WEEKDAY(A1+4,2)=7,4,5)

热心网友 时间：2023-10-22 13:43

在B1输入或复制粘贴下列公式之一
=A1+IF(WEEKDAY(A1+4)=1,5,4)
=A1+IF(WEEKDAY(A1+4,2)=7,5,4)
=A1+IF(WEEKDAY(A1+4,3)=6,5,4)
下拉填充

热心网友 时间：2023-10-22 13:44

=IF(WEEKDAY(TODAY(),2)>5,TODAY()+8-WEEKDAY(TODAY(),2),TODAY())

热心网友 时间：2023-10-22 13:43

=A1+IF(WEEKDAY(A1+4,2)=7,4,5)

热心网友 时间：2023-10-22 13:43

在B1输入或复制粘贴下列公式之一
=A1+IF(WEEKDAY(A1+4)=1,5,4)
=A1+IF(WEEKDAY(A1+4,2)=7,5,4)
=A1+IF(WEEKDAY(A1+4,3)=6,5,4)
下拉填充

热心网友 时间：2023-10-22 13:43

=A1+IF(WEEKDAY(A1+4,2)=7,4,5)

热心网友 时间：2023-10-22 13:44

=IF(WEEKDAY(TODAY(),2)>5,TODAY()+8-WEEKDAY(TODAY(),2),TODAY())

热心网友 时间：2023-10-22 13:43

在B1输入或复制粘贴下列公式之一
=A1+IF(WEEKDAY(A1+4)=1,5,4)
=A1+IF(WEEKDAY(A1+4,2)=7,5,4)
=A1+IF(WEEKDAY(A1+4,3)=6,5,4)
下拉填充

热心网友 时间：2023-10-22 13:44

=IF(WEEKDAY(TODAY(),2)>5,TODAY()+8-WEEKDAY(TODAY(),2),TODAY())