=IF(DATEDIF(A1,TODAY(),"y")<6,INT(DATEDIF(A1,TODAY(),"m")/12)*30,IF(DATEDIF(A1,TODAY(),"y")>=6,150))假设A1为入厂日期，只要把这个公式复制到工龄工资所在单元格就好
