I have a column of dates (I4:I30) with a column next to it for data that has
a new number in it weekly (J4:J30) for 26 weeks that is deducted from a
constant. I then have the result in J2. I can manually change the formula in
J2 weekly to have that weeks current result, but want to have it change
automatically when the weekly number is input in J4:J30. I'm sure there has
to be a way to do this.