JP Fitness Forums - Personal Training - View Single Post - Google SpreadSheet 61 day Tracker Instructions

ohammersmith · 06-02-2007, 12:55 PM

I don't mean half days, I mean account for the current day if I have already recorded it. Because if you put in your number for today, your current + remaining is actually higher than the possible.

I put this forumula above the first column of dates:

=VLOOKUP(B5, A24:B36, 2, 1)

That gives me the number recorded for the current day. Then I just subtracted that from the remaining.

I have to fix it so it will do the lookup on the other columns, but right now that will render an annoying error message that it can't find the column, when I know it won't until later in the month.

06-02-2007, 12:55 PM	#32 (permalink)
ohammersmith Sgt. Max Fightmaster Join Date: Oct 2006 Location: Cary, NC Posts: 448 My Profile	I don't mean half days, I mean account for the current day if I have already recorded it. Because if you put in your number for today, your current + remaining is actually higher than the possible. I put this forumula above the first column of dates: =VLOOKUP(B5, A24:B36, 2, 1) That gives me the number recorded for the current day. Then I just subtracted that from the remaining. I have to fix it so it will do the lookup on the other columns, but right now that will render an annoying error message that it can't find the column, when I know it won't until later in the month. __________________ -Otto. Need printable workout logs? Check out werkit.com for training logs with style. Making a hammer, watch out!