need help developing formula to track weiight loss goals

hi all, im hoping someone can help me with a formula im working on for my spread sheet. long story short im trying to get healthy for the first time in my life, im almost a month into a complete lifestyle change and its going okay so far. ive created a small weight loss journal in excel to help keep me motivated. Ive been advised that a healthy amount of weight you can theoretically lose is 1% of your total body weight (assuming a strict diet and exercise routine).started off well with both, but the last two weeks ive been slacking on the exercise part.

Anyways my spreadsheet shows me what i am losing vs what i theoretically should have lost if i stuck to the diet, figured it would help keep me motivated. going well so far but i thought it would be useful to add a new formula to help give me an added kick in the pants to get off my bum and exercise. i want to figure out how many weeks behind or ahead of schedule i am. the "schedule" is how much i should be losing judging from my starting weight (112.7kg) assuming i lose 1% each week.

Currently im slightly ahead of schedule (about one week) however im attributing that to a short burst of rapid weight loss at the beginning, apparently thats normal when you begin losing weight and then it slows down (which it did). Anyways even though im ahead of schedule i have noticed now that i was missing my weight loss goals, so i have a feeling ill drop behind the "schedule" pretty soon.

Im not quite sure where to start, i know it would involve doing something to the difference between the scheduled weight and the actual weight, but not sure what exactly.


Can anyone help with this? sheet attached

Are you still using Excel 2010?

Please add 5-10 rows of expected outcomes (manually calculated) to your workbook.

Then you need to update your forum profile ASAP.

Please provide some expected results, as requested above.

Sorry - I don't understand the requirement. Explain the formulae you have added - what's the logic?

I want some expected results here:

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	G
2
3
4
5
6
7
8

Sheet: Sheet1

OK - please provide some expected results - when you do this, I'll have a look.

Try the below in cell G3 and drag down:

=IFERROR((D3-E3)/E3+G2,"")

It shows that today you are 0.832311802 weeks ahead

=IFERROR((act loss - goal loss)/goal loss+last weeks result,"")

(act loss - goal loss) = loss over and above target loss
(act loss - goal loss)/goal loss = weeks ahead for that row so: weight loss over and above goal weight loss / goal weight loss
+last weeks result = adds on the previous weeks loss/ gain so as to build a running total

All wrapped in an IFERROR so if the result is an error then the result will be blank

Good luck with your weight loss journey

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks for the rep.