You can make a working bill reminder in Excel with seven columns and four formulas: days left, status, next due date and a total due in the coming week. The formulas below work in Excel 2010 and later and in Google Sheets. Build it once and you only update the due date after each payment.
Which columns do you need?
Put these headers in row 1. Data starts in row 2.
- A: Bill name
- B: Category
- C: Amount (₹)
- D: Next due date
- E: Repeats every (months)
- F: Days left
- G: Status
Enter dates as real dates, for example 18-11-2026, not as text. If a date aligns to the left of its cell, Excel has stored it as text and the formulas below will fail.
What are the formulas?
In F2, days left, with a guard so empty rows stay blank:
=IF(D2="","",D2-TODAY())
In G2, the status:
=IF(F2="","",IF(F2<0,"Overdue",IF(F2<=5,"Due soon","OK")))
Copy both formulas down to row 50. TODAY() recalculates whenever you open the file, so the status updates itself.
How does the next due date move forward?
After you pay a monthly bill, type the next date into D2 with:
=EDATE(D2,E2)
EDATE adds whole months and handles month lengths. For a bill due on 31 January with E2 set to 1, it returns 28 February (or 29 in a leap year). To avoid the formula pointing at itself, copy the cell and Paste Special as Values into D2 after calculating, or compute the new date in a spare column.
How much is due in the next seven days?
Put this in a summary cell:
=SUMIFS($C$2:$C$50,$F$2:$F$50,">=0",$F$2:$F$50,"<=7")
SUMIFS takes the sum range first, then each criteria range and criterion. Blank rows contain empty text in F, so they are ignored. To count overdue bills, use =COUNTIF($G$2:$G$50,"Overdue").
| Bill (invented) | Due | Amount | Days left if today is 14 Nov |
|---|---|---|---|
| Broadband | 17-11-2026 | ₹799 | 3 |
| Rent | 01-12-2026 | ₹16,000 | 17 |
| Card bill | 12-11-2026 | ₹14,300 | -2 |
In that sample, the seven-day total is ₹799, because only broadband falls between 0 and 7 days. The card bill shows Overdue, which is the flag you want to see.
How do you add colour alerts?
Select G2:G50, open Conditional Formatting, choose a rule that uses a formula, and add =$G2="Overdue" with a red fill. Add =$G2="Due soon" with amber. The dollar sign before G locks the column while the row adjusts.
How do you handle bills that are not monthly?
The Repeats every column handles other frequencies. Enter 3 for quarterly, 6 for half-yearly and 12 for yearly bills, and EDATE advances the date by that many months. For a weekly or fortnightly item, replace EDATE with a plain addition such as =D2+14.
- Add a row per bill.
- Set the first due date.
- Set the repeat interval in months.
- After paying, replace D with the next date.
If you share the sheet with family, protect the formula columns so nobody types over them by accident.
What are the limits of a sheet?
A spreadsheet cannot nudge you unless it is open, and it knows nothing about whether you actually paid. Treat it as the source of truth and use your phone calendar for the alerts. Check the file every Sunday evening, and sort by Days left so the most urgent bill is always at the top.
When a sheet stops being enough
Once you track more than twenty bills, or want them next to real spending, typing each date gets tedious. An expense tracker like SpendixAI, where statements are imported and Pro adds bills, budgets and goals, can take over. Until then, the sheet above is free and fully under your control.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

