前後幾天 名稱顯示 (13931)

C2=CHOOSE(B2-E$2+4,"大前天","前天","昨天","今天","明天","後天","大後天")

G2=MATCH(C2,{"大前天","前天","昨天","今天","明天","後天","大後天"},)-4+E$2



留言

張貼留言