=IF(OR(I2="i",I2="it",SUM(IFERROR(FIND({"永盛嘉","乾丰"},C2,1),0))>0),DATE(YEAR(L2),MONTH(L2)+4,-1),IF(IFERROR(FIND("达荣",C2,1),0),DATE(YEAR(L2),MONTH(L2)+4,15),L2+SUM(IF(IFERROR(FIND({"希望","富尔菱","基信"},C2,1),0),{90,90,120},0))+IF(OR(I2="c",I2="bky"),60)))
数组公式 |