电子表格EXCEL表格怎样用函数公式实现租期及租金的自动计算? 知道起租

1.EXCEL表格怎样用函数公式实现租期及租金的自动计算? 知道起租

C2公式：=IF(DATEDIF(A2,IF(B2<>"",B2,TODAY()),"m")=0,"",DATEDIF(A2,IF(B2<>"",B2,TODAY()),"m"))&IF(DATEDIF(A2,IF(B2<>"",B2,TODAY()),"md")=0，"月整"，IF(DATEDIF(A2,IF(B2<>"",B2,TODAY()),"m")=0，""，"月"））&IF(DATEDIF(A2,IF(B2<>"",B2,TODAY()),"md")=0,"",DATEDIF(A2,IF(B2<>"",B2,TODAY()),"md"）&"日"）下拉；E2公式：=IF(DATEDIF(A2,IF(B2<>"",B2,TODAY()),"m")=0,1*LEFT(D2,LEN(D2)-2),DATEDIF(A2,IF(B2<>"",B2,TODAY()),"m")*LEFT(D2,LEN(D2)-2)+DATEDIF(A2,IF(B2<>"",B2,TODAY()),"md")*LEFT(D2,LEN(D2)-2)/30）下拉。

2.excel 怎么计算每月租金

假设上一部份在SHEET1,

SHEET2表格A列（店名列）的顺序与SHEET1的A列（店名列）完全相同，

SHEET2表格B3单元格输入公式

=IF(("2013/"&COLUMN(A1))*1>=SHEET1!$D2，"合同已到期"，INDEX(SHEET1!$E$2:$N$2,DATEDIF(SHEET1!$C2,DATE(2013,COLUMN(A1),1),"Y")+1))

右拉复制再下拉复制公式