Question

excel表格两个日期计算天数遇到小月加1

Answer 1

问：excel表格两个日期计算天数遇到小月加1

答：# C1求A1所在月的天数：=DAY(DATE(YEAR(A1),MONTH(A1)+1,0)) # D1求B1所在月的天数：=DAY(DATE(YEAR(B1),MONTH(B1)+1,0)) # E1求两个日期相差的整月数：=DATEDIF(A1,B1,"m")-1 # F1求A1的天数：=DAY(A1) # G1求B1的天数：=DAY(B1) # 你的所求：=E1+(C1-F1+1)/C1+G1/D1=E1 + 1 +G1/D1 - (F1-1)/C1 # 综合起来：=DATEDIF(A1,B1,"m")+ROUND(DAY(B1)/DAY(DATE(YEAR(B1),MONTH(B1)+1,0)),2)-ROUND((DAY(A1)-1)/DAY(DATE(YEAR(A1),MONTH(A1)+1,0)),2)&"月"