如何用excel公式计算两个日期之间的自然月份数?答:度友,datedif函数配合if函数,eomonth函数可以达到目的,具体公式为:=IF(AND(A2<>"",B2<>""),IF(AND(DAY(A2)=1,DAY(B2)=DAY(EOMONTH(B2,0))),DATEDIF(A2,B2,"M")+1,IF(OR(DAY(A2)=1,DAY(B2)=DAY(EOMONTH(B2,0))),DATEDIF(A2,B2,"M"),DATEDIF(A2,B2,"M")-1)),"")如...