Forum Discussion

Aaron Buchan's avatar
Aaron Buchan
Copper Contributor
Jun 22, 2018

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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond 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.