EXCEL表格怎样用函数公式实现房租交租时间提醒?答:具体公式为:=IF(DATEDIF(TODAY(),DATE(--LEFT(E2,4),--MID(E2,6,2),--RIGHT(E2,4)),"D")>0,IF(AND(MOD((MONTH(TODAY())-(--MID(E2,6,2))),3)=0,OR(DAY(TODAY())+3>=--RIGHT(D2,2),TODAY()<=--RIGHT(D2,2)+3)),"交租","未到期"),"已经结束了")如有疑问...
EXCEL表格怎样用函数公式实现租期及租金的自动计算? 知道起租日及结束...答:)&IF(DATEDIF(A2,B2,"MD")=0,"个月整","个月"&DATEDIF(A2,B2,"MD")&"天"))E2的公式如下并下拉:=IF(DATEDIF(A2,B2,"YM")=0,--LEFT(D2,LEN(D2)-2),LEFT(D2,LEN(D2)-2)*DATEDIF(A2,B2,"YM")+LEFT(D2,LEN(D2)-2)/DAY(EOMONTH(B2,0))*DATEDIF(A2,B2,"MD"))...