如何在excel里面设置剩余年假天数公式

_ahobaka_ 2023-03-19 17:09

• 

  _B吇

  2023-03-19 18:13

  假设日期在A1单元格 在B1中输入或复制资知矿观罗成粘贴下列公式之一=IF(A1="","",慢曲罪如犯结LOOKUP(D质蒸儿象肥生走由曾ATEDIF(A1,TODA且工Y(),"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))下拉填充
  0 讨论(0)
  发布评论:

  提交评论

  ---

  •  加载中...