Hey all,
I've recently discovered Google Docs/Sheets/Presentations and it's all really cool. Now I wonder - because I need it - wether the spreadsheets have a function that sums up the amounts of one column if the date on the same line in the next column is earlier than a certain point. Kind of like a SUMIF, but with a special comparison : a date comparison.
My goal is to be able to have on one hand a sheet with all my incomes and outcomes (yes, it's about money) with their out or in date, and on the other hand, to have a column that shows, for every day of the month, where I'll be at.
Say I start my month with $1000, and I know I'll earn a $3000 salary on the 30th. But I have to pay a $2000 rent by the 20th. Crap !, even though the budget on my first sheet says I'll gain $1000 total this month and wind up at $2000, by the 20th I'll be down $1000, and my bank won't like it ! I want a function that, given a date of the month and the list of dated incomes and outcomes, tells me exactly that - tells me "Crap !" when it needs to be told to me.
Is that possible ? Thanks in advance for all help and tips.
C. T.
No comments:
Post a Comment