Forum Discussion
Enter typical days of months income/expenditure to flow into rolling forecasts
Hi. I have a personal budget where I have set it up so I have a input sheet that has a column for each day which includes details of income or expenses for each day (365 columns for each year). But...
You may modify the layout of your input sheet in such a way that Column A:D are labelled Date, Income, Expense, and Balance, respectively. In D2, copied down rows, the formula is: =SUM(D1,B2,-C2)
Thereafter, you only need to perform a simple VLOOKUP to determine your Balance as at any given date.
Thereafter, you only need to perform a simple VLOOKUP to determine your Balance as at any given date.