excel计算月份公式函数,日期格式为,例如:2000.05到2021.03有几个月...答:对应的公式为:=12*(YEAR(TEXT(SUBSTITUTE(B2,".","-"),"yyyy/mm"))-YEAR(TEXT(SUBSTITUTE(B3,".","-"),"yyyy/mm")))+MONTH(TEXT(SUBSTITUTE(B2,".","-"),"yyyy/mm"))-MONTH(TEXT(SUBSTITUTE(B3,".","-"),"yyyy/mm"))公式为:把单元格B2和B3替换为实际 ...