上面那个也是我答的，就是修改一下二类（L列的公式）保障截止时间（设置“数字”型的，小数位数是0.“常规”型的也应该可以，你可以试试）I列的公式：=IF(K2"","",IF(L2"",YEAR(H2)+2&-MONTH(H2)&-DAY(H2),IF(M2"",YEAR(H2)+1&-MONTH(H2)&-DAY(H2),"")))一类（K列）的公式：=IF(D2>=41,F2,"")二类（L列）的公式：=IF(AND(35.01"","",IF(L2"",YEAR(H2)+2&-MONTH(H2)&-DAY(H2),IF(M2"",YEAR(H2)+1&-MONTH(H2)&-DAY(H2))))一类（K列）的公式：=IF(D2>=41,F2,"")二类（L列）的公式：=IF(35.01"","",IF(L2"",DATE(YEAR(H2)+2,MONTH(H2),DAY(H2)),IF(M2"",DATE(YEAR(H2)+1,MONTH(H2),DAY(H2)),"")))K2=IF(G2/F2>=41,F2,"")L2=IF(G2/F2>41,"",IF(G2/F20，因为前面设的值为空而非0
|
