每日目標金額 以周計 (11734)

A2=YEAR(NOW())

B2=MONTH(NOW())

格式化 H5:H11=WEEKDAY(TODAY(),2)=ROW(A1)

I5:L11=VLOOKUP($H5,$B$5:$F$11,COLUMN(B1),)*C$2/SUMPRODUCT(N(WEEKDAY(ROW(INDIRECT(DATE($A$2,$B$2,1)&":"&DATE($A$2,$B$2,DAY(EOMONTH(DATE($A$2,$B$2,1),0))))),2)=ROW(A1)))