B2 下拉=TEXT(("R"&TEXT(A$2,"0-00-00"))-MOD(WEEKDAY(("R"&TEXT(A$2,"0-00-00")),2),7)+ROW(A1)*7-7,"MMDD")&"-"&TEXT(("R"&TEXT(A$2,"0-00-00"))-MOD(WEEKDAY(("R"&TEXT(A$2,"0-00-00")),2),7)+ROW(A1)*7-1,"MMDD")
=REPLACE(RIGHT(0&SUM(TEXT(("R"&TEXT(A$2,"0-00-00"))-MOD(WEEKDAY(("R"&TEXT(A$2,"0-00-00")),2),7)+ROW(A1)*7-{7,1},"MMDD")*10^{4,0}),8),5,,"-")
留言
張貼留言