Keeping a running balance

Well specifically im looking to fill cells s30 and v30. the info i want is the current balance listed in either column s or v. Look at the "overtime" column and see how it totals at the bottom. I want something similar. The problem is that columns q and t are constants and are part of the formula so all of column s is precalculated. I was sure if there was a way to attach the current leave total with a date or something.

i attached the actual sheet to my original post. If you look at the columns entitled annual and columns entitled sick you will see 3 columns per title. Earned, used, and balance. Earned is constant, so the balance throughout the year will reflect earning total without using any. the only time the balance column changes is if something gets inputted into the used column. I want to have a separate cell show my current balance to make it a little easier to locate. Currently i have to find the row that is designated for the current date.

Yes I want the current total displayed. The totals for future periods are a result of the constants earned. I earn 6 hours every 2 weeks. And as a result of that constants and the formulas used in the table it displays future totals.

unfortunately i didnt see anything of value on the attachment you posted. To answer the other question, if i click on this spreadsheet tomorrow i want it to display current balances in a separate box (s30 or v30) so i can easily locate my current balance. If i open this spreadsheet in 3 weeks i want s30 and v30 to be up to date for that day as well. I need a box that gives me up to date info for the day (or 2 week block) that I am in.