Need help in determining Time Period in which calculation takes place
Hi Guys, just finished designer training and since practice makes perfect, I'm currently trying to build a reporting app for my own personal finances.
Anyway. I would like to have a monitor on my monthly expenses and income. Problem is; I would like to calculate from the moment my salaray is deposited until the next time it is received. And this is unfortunately not a fixed date.
For example; my sheet looks a bit like this (very simplified)
Name / Description
Deposit / Withdrawal
I have made variables for calculating only deposit or withdrawal; no problem. But now I wan't to throw time in the equation.
I would like for it to calculate the Sum of the Deposit or Withdrawal only in the time period starting from the last time 'Salary' can be found in the sheet. So as soon new salary is received it will start calculating again.
Is this possible? If you need any more information or look at my current set analysis I'll be happy to give it.