Offer your thoughts or opinion on the input financial query or topic using your financial background.

How to calculate money needed for bills, by day
If I understand you right, what you need is the minimum amount in the account until your next deposit.  So for example, if today is the 10th and you get paid on the 15th, how much do I need to have in the account, so I know how much I can spend?  That amount should be all of the bills that will be paid between today and the 15th. An alternative would just to keep a running balance and see what the minimum value is. My personal finance software does that for me, but it's possible, although a little more complicated, in Excel.  You'd have to find the date of the next deposit, and do a SUMIF looking for dates between today and that date.  That's about as far as I can get without getting off-topic.