I need a formula to apportion amounts based on a start date. For instance, if I get $1,000 on Monday (Day 1), but I can’t start spending until Wednesday (Day 3), how would I write a formula showing how much was available for spending per day (using an average) until Day 12, and fill in the totals for each week below:
Days 1-7:
Days 8-14:
Days 15-30:
Days 1-7:
Days 8-14:
Days 15-30:
