I'm importing CSV's of all of my transactions in the hopes that I can import a lot of these values into a larger cash flow sheet I've setup elsewhere.
One of the formulas I'm trying to figure out is for Google Sheets to tell me what the balance I have on the first day of each month that is listed on an adjacent drop-down list.
So I have two sets of tables in the following columns:
A,E,F (Date in the format of "MM-DD-YYYY", Transaction Amount, Running Balance): for all of my transactions for the year.
J,K (Month in the format of "MMMM", Balance on the first Day of the month). This list of Months from January-December is in 'J2:J'. The balance on the first day of the adjacent month from 'J2:J' should be listed in 'K2:K'.
For reference, I have the monthly date ranges setup on another tab via column A,B,C -> Month, First Day, Last Day. This was already setup to filter by month on the same sheet, so I'm assuming I could use this to also figure out what the first date of the month is. However, I cannot figure out how to pull the balance from the first day of the month.
Similarly, I'm also interested in figuring out what the sum of all of the transactions that have occurred during a specified month (E2:E) are as well.
Here is the sheet: https://docs.google.com/spreadsheets/d/1aj44YJIrk6el_L0TexQeuLxYapvkXt2b1RbQBwPL13o/edit?usp=sharing