符合周一 ~ 周五日期 取資料 (13978)

G2{=IFERROR(VLOOKUP(5-WEEKDAY(F2,2)+F2,IF({1,0},5-WEEKDAY(B$2:B16,2)+B$2:B16,D$2:D16),2,),"XX")

H2=IFERROR(LOOKUP(1,0/MATCH(B$2:B16,ROW(INDIRECT(1-WEEKDAY(F2,2)+F2&":"&5-WEEKDAY(F2,2)+F2)),),D$2:D16),"XX")