就是有一个期间,把它分拆到每个月分别占用的天数是多少,下面的D3公式返回的数值是0
如图C3=IFERROR(INDEX(TEXT($A$2+ROW(INDIRECT("a1:a"&$B$2-$A$2+1,1))-1,"YYYY-MM"),SMALL(IF(MATCH(TEXT($A$2+ROW(INDIRECT("a1:a"&$B$2-$A$2+1,1))-1,"YYYY-MM"),TEXT($A$2+ROW(INDIRECT("a1:a"&$B$2-$A$2+1,1))-1,"YYYY-MM"),0)=ROW(INDIRECT("a1:a"&$B$2-$A$2+1,1)),ROW(INDIRECT("a1:a"&$B$2-$A$2+1,1)),4^8),ROW(A1))),"")D3=IFERROR(SUM(1*(TEXT($A$2+ROW(INDIRECT("a1:a"&$B$2-$A$2+1,1))-1,"YYYY-MM")=C2)),"")数组公式,下拉复制
看不到图
再传一下
热门标签: