如果A1是入职时间，那么在需要计算年假的地方输入以下公式：=IF(2+(TEXT(TODAY()-A1,"y"))>=7,7,IF(2+(TEXT(TODAY()-A1,"y"))<3,"",2+(TEXT(TODAY()-A1,"y"))))
很简单啊 用函数就可以了
