excel怎样取一个日期加上20个月的倍数最终大于现在的日期答:=IF(INT(DATEDIF(A1,TODAY(),"M")/20)=DATEDIF(A1,TODAY(),"M")/20,DATE(YEAR(A1),MONTH(A1)+(DATEDIF(A1,TODAY(),"M")/20)*20,DAY(A1)),DATE(YEAR(A1),MONTH(A1)+(DATEDIF(A1,TODAY(),"M")/20+1)*20,DAY(A1)))当前单元格日期为 A1单元格的日期 加上 20*N个月后 ...