A1和B1分别输入日期 且A1<=B1在C1中输入或复制粘贴下列公式=DATEDIF(A1,B1,"m")或=CEILING(DATEDIF(DATE(YEAR(A1),MONTH(A1),1),EOMONTH(B1,0),"d")/30,1)