•4 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Calculating Bills based on Due date and Paychecks that fall in that date range
Our take
Managing bills can be a daunting task, especially when trying to align payments with your bi-weekly paycheck schedule. By automating the calculation of how much to set aside based on bill due dates and the paychecks received in that timeframe, you can simplify your financial planning. In this discussion, we’ll explore a method that calculates your required savings for bills, ensuring you remain on top of your financial commitments without the stress of manual tracking. Let’s discover how this approach can enhance your budgeting experience.
Hi All, I'm trying to find a way to automatically calculate how much i need to set aside for bills based on bill due dates, and the amount of paychecks that fall between the previous due date and the next due date. my Direct deposit happens bi weekly on thursdays, the table below is an example of how i do it currently.
| May | Due Date | Check 3 | Amount Due | Per Check | Amount In Savings | Paid | Remaining Balance | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Rent | 1-May | 4/9/2026 | 4/23/2026 | 1817.49 | 908.75 | $908.75 | $1,817.49 | |||||
| Car Payment | 1-May | 4/9/2026 | 4/23/2026 | $597.00 | 298.50 | $298.50 | $597.00 | |||||
| Sofi Loan | 7-May | 4/23/2026 | 5/7/2026 | $137.60 | 68.80 | $0.00 | $137.60 | |||||
| GT500 Payment | 13-May | 4/23/2026 | 5/7/2026 | $175.00 | 87.50 | $0.00 | $175.00 | |||||
| Credit Card | 13-May | 4/23/2026 | 5/7/2026 | $392.00 | 196.00 | $0.00 | $392.00 | |||||
| Verizon | 14-May | 4/23/2026 | 5/7/2026 | $161.08 | 80.54 | $0.00 | $161.08 | |||||
| poiwer | 14-May | 4/23/2026 | 5/7/2026 | $82.87 | 41.44 | $0.00 | $82.87 | |||||
| gas | 14-May | 4/23/2026 | 5/7/2026 | $26.91 | 13.46 | $0.00 | $26.91 | |||||
| Fed Loan | 18-May | 4/23/2026 | 5/7/2026 | $52.49 | 26.25 | $0.00 | $52.49 | |||||
| Xfinity | 21-May | 5/7/2026 | 5/21/2026 | $75.00 | 37.50 | $0.00 | $75.00 | |||||
| Water Utility | 23-May | 5/7/2026 | 5/21/2026 | $70.00 | 35.00 | $0.00 | $70.00 | |||||
| Savings | 28-May | 5/7/2026 | 5/21/2026 | $1,806.74 | 903.37 | $0.00 | $1,806.74 |
i manually fill in the paycheck dates that then use an if statement to calculate the number of pay checks, and divide the bill total by to then fill out a seperate set of columns that tells me the amount per check
| Bill | Week 1 | Week 2 | Total |
|---|
| Rent | $0.00 | $908.75 | $908.75 |
|---|---|---|---|
| Car Payment | $0.00 | $298.50 | $298.50 |
| Sofi Loan | $0.00 | $0.00 | $0.00 |
| GT500 Paymet | $87.50 | $0.00 | $87.50 |
| BestBuy Credit Card | $179.18 | $0.00 | $179.18 |
| Verizon | $82.18 | $0.00 | $82.18 |
| Power | $41.44 | $0.00 | $41.44 |
| Gas Co | $15.28 | $0.00 | $15.28 |
| Fed Loan | $26.25 | $0.00 | $26.25 |
| Xfinity | $37.50 | $0.00 | $37.50 |
| Water Utility | $35.00 | $0.00 | $35.00 |
| Savings | $903.37 | $0.00 | $903.37 |
| Total | $2,614.94 | ||
| Remaining Balance | 1,542.44 |
[link] [comments]
Read on the original site
Open the publisher's page for the full experience