每月占用天数 (10902)

 

D3:O11=TEXT(INDEX(FREQUENCY(ROW(INDIRECT((D$2&"/1")*1&":"&EOMONTH(D$2&"/1",0))),SUBSTITUTE($A3:$B3,".","/")-{1,0}),2),"0;;")

無占用天数0 顯 0=SUMPRODUCT(N(MONTH(ROW(INDIRECT(SUBSTITUTE($A3,".","/")*1&":"&SUBSTITUTE($B3,".","/")*1)))=D$2))

無占用天数0 顯 0=MAX(MIN(SUBSTITUTE($B3,".","/"),EOMONTH(D$2&"/1",0))+1-MAX(SUBSTITUTE($A3,".","/"),D$2&"/1"),)