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替换为实际 ...
如何用excel从身份证号码提取生活了几个月或者几天?答:假设18位的身份证号写在A1单元格,则可以在B1单元格写入公式 生活了几个月 =DATEDIF(TEXT(MID(A1,7,8),"0-00-00"),NOW(),"m")生活了多少天 =DATEDIF(TEXT(MID(A1,7,8),"0-00-00"),NOW(),"d")
excel计算两个日期之间有几年几个月答:=DATEDIF(SUBSTITUTE(B2,".","-"),SUBSTITUTE(C2,".","-"),"Y")&"年"&DATEDIF(SUBSTITUTE(B2,".","-"),SUBSTITUTE(C2,".","-"),"YM")&"个月"