- ·上一篇：电子表格wps excel文件不能完整显示
- ·下一篇：电子表格怎么用excel2007制作进度计划图
电子表格EXCEL如何用函数计算儿童年龄月龄?
2026-01-18 11:51:09
1.EXCEL如何用函数计算儿童年龄月龄?
用这个公式：=INT(DATEDIF(SUBSTITUTE(A1,".","-"),SUBSTITUTE(B1,".","-"),"m")/12)&"y"&DATEDIF(SUBSTITUTE(A1,".","-"),SUBSTITUTE(B1,".","-"),"m")-INT(DATEDIF(SUBSTITUTE(A1,".","-"),SUBSTITUTE(B1,".","-"),"m")/12)*12&"m"