0

How to calculate the remaining amount to spend for a specific day (that day is today).

So, I have the budget for one month (let's say 1000$).
My daily spending is 32.25$.
If I spent 20$ today, is there a possibility to see how much is left for today?

So basically we have 3 steps.

  1. SUM all transactions from today's date

  2. Subtract from the daily budget(I can put it in a separate cell, or I can put it in the same cell)

  3. Show the result in cell

    Link to the sheet: https://docs.google.com/spreadsheets/d/1AhreVRWJyMoG5JR-qvtK3Jq9K98G3L_-oIn6ju0Ssmk/edit?usp=sharing

6
  • If you share an editable sample google sheet, it can be shown how to do it.
    – MattKing
    Feb 6, 2020 at 22:40
  • My apologies becouse i didn't include sheet.
    – inchillout
    Feb 7, 2020 at 5:10
  • Yes it is possible to search sum of all today's transactions and then subtract that from the daily budget as you ask. But it will not be possible (for me) without a link to a share SAMPLE of the sheet. not the real thing, just a sample.
    – MattKing
    Feb 7, 2020 at 13:27
  • Please read how to and share a test sheet so as you can be easier helped. Feb 7, 2020 at 17:32
  • Thank you for your help @MattKing, included sample of sheet. I am sorry for mistakes, i am new commer here :) And hope that anybody else need something like this. Cheers.
    – inchillout
    Feb 8, 2020 at 1:52

1 Answer 1

0

Edited answer

(following OP's comment on the sheet: "Daily budget would be determined by Planned expenses (C22 cell) divided by number of days in month.")

Your final needed formula would be:

=(SUMIF(Transactions!B5:B44;"="&(TODAY());Transactions!C5:C44))-
       C22/(EOMONTH(TODAY();0)-(EOMONTH(TODAY();-1)))

To summarize, these are the 3 formulas you will need to get your expected result:

+-------------------------+------------------------------------------------------------------+-------------+
|      We used A-B=C      |                             Formulas                             | Test Result |
+-------------------------+------------------------------------------------------------------+-------------+
| A. today's transactions | =SUMIF(Transactions!B5:B44;"="&(TODAY());Transactions!C5:C44)    | ₩360.700    |
| B. daily budget         | =C22/(EOMONTH(TODAY();0)-(EOMONTH(TODAY();-1)))                  | ₩34.448     |
| C. remaining for today  | =(SUMIF(Transactions!B5:B44;"="&(TODAY());Transactions!C5:C44))- |             |
|                         |    C22/(EOMONTH(TODAY();0)-(EOMONTH(TODAY();-1)))                | ₩326.252    |
+-------------------------+------------------------------------------------------------------+-------------+

Note: One may have to replace ; with , according to the sheet,s locale.


Original answer

If I understand you well, the formula you would need is:

=(SUM all transactions from today's date)-(daily budget)

=(SUMIF(Transactions!B5:B44;"="&TODAY();Transactions!C5:C44))-(daily budget)

You can place the formula in cell L10 (Today left) to see the result.

Note: I don't understand what you mean or how you calculate your "daily budget" so I leave this part for you.
Still. If you need further assistance please let us know.

2
  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. Feb 8, 2020 at 4:13
  • Thank you very much @marikamitsos for making this answer! This was all i needed. And also this was really helpful for my knowlage with google sheets. I understand now how to deal with date in sheets.
    – inchillout
    Feb 9, 2020 at 1:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.