# Calculating Money Remaining

#### JaydenExcel707

##### New Member
Hello all,

I need some help. What I am trying to do is calculate how much money is remaining on a bill based on how much time has passed from todays current date. I have it set up for how much i would cost monthly. Thats fine. It is how much money should be remaining based off of the current date and monthly payments that should have been paid up until this point.

Essentially every time I log in, I want the excel spreadsheet to calculate how much money is remaining if I stuck to my monthly cost.

So in the screen shot. If I have 48 days remaining, if I log in in 10 days from now I want it to know how much should be deducted from the base value based on how many days are left.

Note I am purposely not adding the monthly payments on this worksheet as time goes.

#### Attachments

• Capture.PNG
5.8 KB · Views: 9

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

#### Ezguy4u

##### Board Regular
Jay I am going to say there isn't enough information here to be able to solve the problem. Now it would be nice to post an example of input and output using that XL2BB. But at least show us the math you want to use to come up with an answer. Does the \$200 Bills Cost figure into the math? I would suggest figuring the cost per day. Month Cost of Event is not very informative. How many days in a month? Let the discussion begin.

#### pedro-egoli

##### Well-known Member
The following may not be what you are after but may provide some guide
Book1
ABCDEFGH
1budget \$200
2makes daily for period\$4.17
3Period7/11/202025/12/2020
48/11/202015/11/202025/11/202014/12/202025/12/2020
5remaining should be \$196\$167\$125\$46\$0
Sheet1
Cell Formulas
RangeFormula
B2B2=B1/SUM(C3-B3)
D5:H5D5=\$B\$1-(D4-\$B3)*\$B\$2

#### JaydenExcel707

##### New Member
You are amazing. It completely worked. I just had to adjust days to months but yes. Thank you so so much!!

#### pedro-egoli

##### Well-known Member
You are amazing. It completely worked. I just had to adjust days to months but yes. Thank you so so much!!
glad you got it to work and thanks for feedback

Replies
0
Views
195
Replies
0
Views
88
Replies
9
Views
602
Replies
29
Views
543
Replies
1
Views
70