英文星期 月改中文 (14365)

C2=LOOKUP(1,0/(TEXT(ROW($1:$7),"DDDD")=B2),TEXT(ROW($1:$7),"AAAA"))

F2=LOOKUP(1,0/(TEXT(DATE(1,ROW($1:$12),1),"MMMM")=E2),ROW($1:$12))&"月"