- ·上一篇：excel表格中怎么体现字数
- ·下一篇：怎么做计划表格excel表格
excel表格表怎么算月龄
2024-07-19 13:51:54
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"