I need a formula for each cell to apportion amounts based on a start date. For instance, if I get $100 on Monday (Day 1), but I can’t start spending until Wednesday (Day 3), how would I write a formula showing how much I could spend per day 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:
