產生一周起止日 (13167)

B2:C2下拉=TEXT(LEFT(B1,FIND("~",B1)-1)+7,"YYY/M/D")&"~"&TEXT(LEFT(B1,FIND("~",B1)-1)+13,"YYY/M/D")

B10:C10下拉=TEXT(B$9-MOD(B$9-2,7)+ROW(A1)*7-7,"YYY/M/D")&"~"&TEXT(B$9-MOD(B$9-2,7)+ROW(A1)*7-1,"YYY/M/D")