Calculating Money Remaining

[JaydenExcel707]

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.

 

[Ezguy4u]

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]

As Ezguy4u said more info needed.
The following may not be what you are after but may provide some guide

Book1
	A	B	C	D	E	F	G	H
1	budget	$200
2	makes daily for period	$4.17
3	Period	7/11/2020	25/12/2020
4				8/11/2020	15/11/2020	25/11/2020	14/12/2020	25/12/2020
5		remaining	should be	$196	$167	$125	$46	$0
Sheet1

Cell Formulas
Range	Formula
B2	B2	=B1/SUM(C3-B3)
D5:H5	D5	=$B$1-(D4-$B3)*$B$2

 

[JaydenExcel707]

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

 

[pedro-egoli]

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