Forum Discussion
Aaron Buchan
Jun 22, 2018Copper Contributor
Daily Spending Average
I am hoping someone can help me. I am creating a personal workbook that budgets my disposable spending during a pay period. I want to have a column that shows what the average I can spend daily based on my allotted budget. As I progress daily through that pay period putting in the spending for a current day, I need a formula that will recalculate my average daily spending, updating it to only include the remaining days in that pay period and the remaining budgeted amount left. I hope that makes sense. If someone could help me I would appreciate it.
1 Reply
- SergeiBaklanDiamond Contributor
Hi Aaron,
Could you please provide small sample file which shows how your data is structured, it will be easier to suggest the formula.