假设A1单元格写入入职日期,B1单元格写入截止日期
则C1单元格写入公式
公式一
="在职"&IF(DATEDIF(A1,B1,"D")<15,"半个月",IF(DATEDIF(A1,B1,"MD")<15,DATEDIF(A1,B1,"M")&"个半月",DATEDIF(A1,B1,"M")+1&"个月"))
公式二
="在职"&DATEDIF(A1,B1,"M")+IF(DATEDIF(A1,B1,"MD")<15,0.5,1)&"个月"
公式三
=DATEDIF(A1,B1,"M")+IF(DATEDIF(A1,B1,"MD")<15,0.5,1) 再设置单元格格式为常规