先写一个公式=IF(DAY(A1)>15,TEXT(C1-A1,"e-m")+1,TEXT(C1-A1,"e-m"))A1表示入职日期，根据实际修改单元格地址C1为截至日期，根据事情情况改动！
=TEXT(DATEDIF(A1,TODAY(),"y"),"#年")&TEXT(DATEDIF(A1,TODAY(),"ym"),"#月;;;")
