Here?s what I think will give you the projected number of days it will take to lose the remaining weight as of today. I?m assuming that column ?A? contains the dates, and column ?B? contains your weights on each date, so the bottom row contains today?s date and today?s weight.
Calculate the pounds you still have to lose as of today:
(Formula A)
= (INDIRECT("B"&ROW()) - 190) (=lbs )
Calculate your average weight for the last 10 days:
(Formula B)
= AVERAGE(INDIRECT("B"&ROW()-9):INDIRECT("B"&ROW()) (= lbs)
Calculate your average weight loss for the last 10 days:
(Formula C)
= (Formula B) ? (INDIRECT("B"&ROW())) (= lbs)
Calculate your average weight loss per day during the last 10 days:
(Formula D) = (Formula C) / 10 (= lbs/day)
Calculate how many days it will take from today to lose the remaining weight:
= (Formula A) / (Formula D) (=lbs/(lbs/day)=days)
I think I?ve copied this correctly from my worksheet, but be VERY careful to put you parentheses in the correct locations.
If it works, then use column ?D? to put this formula, and each day copy it down to the next row and it should give you a revised projection.