如果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)))