求Excel年假计算公式答:在C2中输入或复制粘贴下列公式 =FLOOR(IF(B2<DATE(2017,1,1),10,YEARFRAC(DATE(YEAR(NOW()),MONTH(B2),DAY(B2)),DATE(YEAR(NOW()),12,31),3)*10),0.5)下拉填充
求教excel中如何计算年假天数? 急!!!谢谢!!!答:若入职日期在C列,那么 当年应休年假天数D列中D3输入=IF(LOOKUP(DATEDIF(C3,TODAY(),"Y"),{0,1,10,20},{0,5,10,15})=0,ROUND(DATEDIF(C3,TODAY(),"d")/365*5,0),LOOKUP(DATEDIF(C3,TODAY(),"Y"),{0,1,10,20},{0,5,10,15}))...
如何在excel里面设置剩余年假天数公式答:假设日期在A1单元格 在B1中输入或复制粘贴下列公式之一 =IF(A1="","",LOOKUP(DATEDIF(A1,TODAY(),"Y"),{0,1,2,3,4,5},{0,8,9,10,11,12}))或 或 =IF(DATEDIF(A1,"2015/12/31","Y")<1,0,IF(DATEDIF(A1,"2015/12/31","Y")>5,12,DATEDIF(A1,"2015/12/31","Y")+7...
excel计算年假,急求公式,谢谢答:如天数放在A1,插入一个公式,然后公式下拉。=LOOKUP(A1,{0,1.1,3.1,5.1,7.1,8.1},{0,5,6,7,8,10})更多WPS办公软件教程,请访问:http://bbs.wps.cn
年假天数Excel的计算方法答:>=365,ROUNDDOWN((DATE(2017,12,31)-DATE(YEAR(A2),MONTH(A2),DAY(A2))-365)/365*5,0),0)C2:=ROUNDDOWN((DATE(2017,12,31)-DATE(YEAR(A2),MONTH(A2),DAY(A2))-365)/365*5,0)答案有误差,和你描述的应该是多减了2天,把ROUNDDOWN()去掉看结果 另外看第四行,公式我猜的 ...
请问如何在Excel表格中设公式自动显示年假天数?答:=LOOKUP(A1,{1,2,3,10,20},{5,6,7,10,15}),A1字段放工龄 =LOOKUP(A1,{1,2,3,4,10,11,20},{7,8,9,10,11,12,15})