•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#cloud-based spreadsheet applications
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#Due date
#Paychecks
#bills
#bill calculation
#amount due
#Rent
#Car Payment
#automated calculation
#direct deposit
#per check
#payment schedule
#bi-weekly
#savings