距今天指定天数的单元格数 (11194)

F2:G2=INDEX(FREQUENCY(($B2:$B16-$D2)*-1^(B1=$C1),$E5:$E6-{1;0}),2)

另解{=COUNT(PERCENTRANK({14,20}*-1^(B1=$B1),$D2-$B2:$B16))

之後格式化=MEDIAN(B2-D$2,E$5:E$6)=B2-D$2