K2:K14=DATEDIF(E2,B$2,"d")*(J2>0)
N2:S14=IF($J2,REPT($J2,LOOKUP($K2,{0,31,61,91,366,1096},COLUMN($A:$F))=COLUMN(A1)),"")
N2:S14另解=IF($J2,REPT($J2,INDEX(FREQUENCY($K2,{0,30,60,90,365,1095}),COLUMN(B1))),"")
N2:S14另解=IF($J2,REPT($J2,MATCH($K2,{0,31,61,91,366,1096})=COLUMN(A1)),"")
留言
張貼留言