生日提前幾天 彙整 (13438)

G2:H11{=IFERROR(INDEX(A:A,SMALL(IF((TEXT($B$2:$B$16,"M/D")-TEXT($E$2,"M/D")>=0)*(TEXT($B$2:$B$16,"M/D")-TEXT($E$2,"M/D")<=$E$6),ROW($2:$16)),ROW(A1))),"")

B2:B16格式化=(TEXT(B2,"M/D")-TEXT(E$2,"M/D")>=0)*(TEXT(B2,"M/D")-TEXT(E$2,"M/D")<=E$6)