Excel到期后自动增加3个月?

2025-02-25 22:17:28
推荐回答(1个)
回答1:

如果A1单元格为入职日期,B1单元格中结束日期,则在B1单元格内输入:

=IF(TODAY()>DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)),DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)),DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)))