Hey all,
Still learning how to use excel, however I have a budget sheet I made I've been using for the past few years. Simple stuff, just my income vs outcome vs savings.
This year I've added a "Wish List" Sheet to it, and I was wondering if anyone could help me with a formula.
So I have my Overview sheet beginning by week, which gives me a number in a separate column of how much I have available in checking, after subtracting savings, spendings, and recurring bills.
On a separate sheet I have a Wish list of items I want, with their respective prices and what I am willing to spend for such items.
The Question:
How can I generate an automatic (week beginning) date for when I am able to spend x-amount of money, only if the total in checking at the end of the month is greater than a certain amount?
Example:
Sheet1
Date Income Outcome Checking Savings
2/4/19 100 25 26 49
Sheet 2:
Item 1 Price Date Available
x $1 (automatically generated to 2/4/19 if checking is still greater than 25$ after subtracting price)
Bonus Formula:
Date Available
(automatically generated to 2/4/19 if checking is greater than 25 AND savings is greater than 48)
Still learning how to use excel, however I have a budget sheet I made I've been using for the past few years. Simple stuff, just my income vs outcome vs savings.
This year I've added a "Wish List" Sheet to it, and I was wondering if anyone could help me with a formula.
So I have my Overview sheet beginning by week, which gives me a number in a separate column of how much I have available in checking, after subtracting savings, spendings, and recurring bills.
On a separate sheet I have a Wish list of items I want, with their respective prices and what I am willing to spend for such items.
The Question:
How can I generate an automatic (week beginning) date for when I am able to spend x-amount of money, only if the total in checking at the end of the month is greater than a certain amount?
Example:
Sheet1
Date Income Outcome Checking Savings
2/4/19 100 25 26 49
Sheet 2:
Item 1 Price Date Available
x $1 (automatically generated to 2/4/19 if checking is still greater than 25$ after subtracting price)
Bonus Formula:
Date Available
(automatically generated to 2/4/19 if checking is greater than 25 AND savings is greater than 48)
