如何用Excel表格设置工资年限累计计算?答:在Excel表格里面可以使用IF、ROUNDDOWN、MOD、DATEDIF函数来计算工作年限(计算到月),示例如下:一、在C2单元格里面输入公式=IF(ROUNDDOWN(DATEDIF($A2,$B2,"M")/12,0)>0,ROUNDDOWN(DATEDIF($A2,$B2,"M")/12,0)&"年","")&IF(MOD(DATEDIF($A2,$B2,"M"),12)>0,MOD(DATEDIF($A2,$B2...
excel表格里面怎么计算工作年限?怎么输入公式?答:=datedif(B2,C2,"Y")如果计算到今天,则 =datedif(B2,NOW(),"Y")如果要准确到年月日,可用如下公式:=DATEDIF(B2,C2,"Y")&"岁"&DATEDIF(B2,C2,"YM")&"个月零"&DATEDIF(B2,C2,"MD")&"天"或 =DATEDIF(B2,NOW(),"Y")&"岁"&DATEDIF(B2,NOW(),"YM")&"个月零"&DATEDIF(B2,...