C1=IF(ROW(A1)*7-MOD(A$2-2,7)-6>DAY(EOMONTH(A$2,0)),"",(ROW(A1)*7-MOD(A$2-2,7)-6)^(ROW(A1)>1)&"-"&MIN(ROW(A1)*7-MOD(A$2-2,7),DAY(EOMONTH(A$2,0))))
另解=IF((8-WEEKDAY(A$2,2))+ROW(A1)*7-13>--TEXT(EOMONTH(A$2,0),"d"),"",MAX(1,(8-WEEKDAY(A$2,2))+ROW(A1)*7-13)&"-"&MIN(TEXT(EOMONTH(A$2,0),"d"),(8-WEEKDAY(A$2,2))+ROW(A1)*7-7))
留言
張貼留言