同日期有任一出現 即為 1(9162)

F2:K5=IF(SUMPRODUCT(($B$2:$B$21=$E2)*($C$2:$C$21=F$1)),1,"")

另解{=IF(OR(($B$2:$B$21=$E2)*($C$2:$C$21=F$1)),1,"")

另解=IF(COUNTIFS($B:$B,$E2,$C:$C,F$1),1,"")