如题所述
对应的公式为:
=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替换为实际
1、在B2单元格中输入公式:
=DATEDIF(SUBSTITUTE(A2,".","-"),SUBSTITUTE(A3,".","-"),"m")
2、选中B2和B3单元格,单击合并后居中按钮,如图: