起止年 找黑色星期五 (15199)

日期：

C2右拉 下拉 {=IFERROR(SMALL(IF(WEEKDAY(DATE(ROW(INDIRECT(SUBSTITUTE(C$1,"~",":"))),COLUMN($A:$L),13),2)=5,DATE(ROW(INDIRECT(SUBSTITUTE(C$1,"~",":"))),COLUMN($A:$L),13)),ROW(A1)),"")



留言

張貼留言