Forum Discussion
Excel Calender worksheet
- Nov 13, 2021
JennyRae87 Oh my! I understand what you want to do, but not why you use a calendar template for it. Templates like these are often quite useless, even for the purpose they where designed for. And they are most definitely not designed to keep track of a budget. Wouldn't really know where to begin analysing the workbook to find where it goes wrong.
Consider a totally different approach. Create structured table where you enter all your expenses as they occur (Date, Amount, Description) and then create a pivot table to summarise the expenses.
JennyRae87 "the Excel calendar template". Which one? There are many different ones available. Can you upload the template you are using with som fake data in it, demonstrating what you are trying to do?
- JennyRae87Nov 13, 2021Copper ContributorI want to keep track the amount of money I have been spending per day, but when I placed the money formulas into January, they copied to the following months.
- Riny_van_EekelenNov 13, 2021Platinum Contributor
JennyRae87 Oh my! I understand what you want to do, but not why you use a calendar template for it. Templates like these are often quite useless, even for the purpose they where designed for. And they are most definitely not designed to keep track of a budget. Wouldn't really know where to begin analysing the workbook to find where it goes wrong.
Consider a totally different approach. Create structured table where you enter all your expenses as they occur (Date, Amount, Description) and then create a pivot table to summarise the expenses.