excel表格如何在时间区间提取出总天数?答:A1,LEN(A1)-FIND("-",A1)),".","-")-SUBSTITUTE(LEFT(A1,FIND("-",A1)-1),".","-") 或者:=SUM(TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"-",REPT(" ",99)),".","-"),{1,100},99))*{-1,1})这个是数组公式,公式输入完后按【CTRL+SHIFT+回车】后,才能正确计算结果 ...
Excel 用什么公式可以计算工作天数和年假天数答:D1=ROUND(LOOKUP(DATEDIF(B1,TODAY(),"Y"),{0,1,10,20},{0,5,10,15})*MIN(DATEDIF(C1,DATE(YEAR(TODAY()),12,31),"D")/365,1),1)