將日期自動填入區間 (12770)

C2:H13=IF((LEFT(C$1,FIND("-",C$1)-1)-TEXT("1年"&$A2,"M/D")<=0)*(MID(C$1,FIND("-",C$1)+1,9)-TEXT("1年"&$A2,"M/D")>=0),$A2,"")

超出H1日期 顯示於H1=REPT($A2,LOOKUP(1,0/(LEFT($C$1:$H$1,FIND("-",$C$1:$H$1)-1)-TEXT("1年"&$A2,"M/D")<=0),COLUMN($A:$F))=COLUMN(A1))