So I have created a financial document where I can manage all of my income/expenses/bills and so fourth. I have been slowly upgrading the functions in this spreadsheet so that the data I end up with is more accurate and I'm not putting in every number and doing all of the calculations manually. There is one function or group of functions I am having difficulty figuring out. If you look at the example below I can explain everything.
Example.xlsx
So on the left, for every day to day expense I will document the date of purchase, the name of where the purchase was made, the category of that purchase, and how much. Now on the right I keep track of the expenses on a week to week basis. Here is what I am looking to do. I need to figure out a function that if I put an expense on the left side with the date, type and amount, the function will determine that depending on the date it will complete a function in the column of that week. Also within that week, depending on the type of expense it is, it will perform a SUM function within that week and put the total for each type of expense in the correct cell.
So far, I have figured out one of the ladder logic SUMIF functions that depending on the type of expense in column C, the amount in column D will be added to the correct sell for that week. The part I can't figure out, is how to set it up so it can determine what week column it goes in based on the date.
To use one of the entries in the example, on June 4th I went to the ATM and took out $60. The spreadsheet should be set up so it knows that June 4th is in the first week of the month, and the amount gets added to the ATM-Week1 cell in G4 because the type of expense is an ATM expense.
Any help is good help Thank you in advance.
Bookmarks