Calculating Money Remaining

JaydenExcel707

New Member
Joined
Nov 7, 2020
Messages
2
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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
    Capture.PNG
    5.8 KB · Views: 9

Some videos you may like

Excel Facts

Add Bullets to Range
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
Joined
Feb 10, 2010
Messages
139
Office Version
  1. 2019
Platform
  1. Windows
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
Joined
Apr 25, 2004
Messages
1,217
Office Version
  1. 2016
Platform
  1. Windows
As Ezguy4u said more info needed.
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
Joined
Nov 7, 2020
Messages
2
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
You are amazing. It completely worked. I just had to adjust days to months but yes. Thank you so so much!!
 

Watch MrExcel Video

Forum statistics

Threads
1,119,014
Messages
5,575,549
Members
412,677
Latest member
Davejf81
Top