201612201524整月自动生成以星期五至下星期四为周期的日期 (2837)

B10=B8

B11=LOOKUP(1,0/(WEEKDAY(B3+ROW(1:7)-1,2)=5),ROW(1:7))+B3-2

C10:G11=IF(MIN(B$6+1+(ROW(A1)=2)*6,EOMONTH($B$3,0))=B$6,"",MIN(B$6+1+(ROW(A1)=2)*6,EOMONTH($B$3,0)))

B13:G14=IF(B5="","",TEXT(WEEKDAY(B5,1),"AAA"))

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank





Powered by Xuite