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.
