The monthly saving needed for a goal is the amount still to be saved divided by the whole months left until your goal date. In Excel that is (target minus saved so far) divided by DATEDIF(TODAY(), goal date, "m"). This version assumes no interest or returns, so it gives a plain, conservative number you can adjust later.
Which cells does the calculator need?
Set up five labelled cells on a fresh sheet. The formulas below point at exactly these addresses:
- B1: target amount, for example 120000
- B2: saved so far
- B3: goal date, typed as a real date
- B4: months remaining (formula)
- B5: monthly saving needed (formula)
- B6: progress percentage (formula)
How do you count the months remaining with DATEDIF?
DATEDIF returns the number of complete months between two dates. In B4 enter:
=IF(B3<=TODAY(), 0, DATEDIF(TODAY(), B3, "m"))
The IF guard matters because DATEDIF returns an error when the start date is later than the end date. A small oddity to know: DATEDIF works in Excel and Google Sheets, but Excel does not list it when you start typing, so type the full name yourself. It also counts only full months, so a goal date 14 months and 20 days away shows 14.
What is the monthly amount formula?
In B5 divide what is left by the months left, and stop it from showing a negative number once the target is already met:
=IF(B4=0, "Goal date reached", MAX(B1-B2, 0)/B4)
Round up to the nearest ₹100 so you do not fall short by a few rupees each month:
=IF(B4=0, "Goal date reached", CEILING(MAX(B1-B2, 0)/B4, 100))
CEILING with two arguments works in both Excel and Google Sheets. For progress, put this in B6 and format it as a percentage:
=IF(B1>0, MIN(B2/B1, 1), 0)
What does a worked example give?
Say you are saving for a family trip that you expect to cost ₹1,20,000. You have ₹30,000 set aside already and the goal date is 15 whole months away.
- Still to save: ₹1,20,000 minus ₹30,000 equals ₹90,000
- Monthly amount: ₹90,000 divided by 15 equals ₹6,000
- Progress: ₹30,000 divided by ₹1,20,000 equals 25%
How does the answer change if you move the date?
The useful part of a sheet is trying dates. Same target and same ₹30,000 saved, only the months left change:
| Months left | Still to save | Monthly amount |
|---|---|---|
| 12 | ₹90,000 | ₹7,500 |
| 15 | ₹90,000 | ₹6,000 |
| 18 | ₹90,000 | ₹5,000 |
| 24 | ₹90,000 | ₹3,750 |
If ₹7,500 does not fit your month, you now know exactly how many extra months it takes to reach a figure you can live with. Compare the monthly amount against what is left after rent, groceries and EMIs, not against your whole salary.
A related question is how a windfall changes the answer. If you add a ₹10,000 bonus to B2, the amount left falls to ₹80,000 and, over the same 15 months, the monthly figure falls to about ₹5,333, which is 80,000 divided by 15. Typing a different value in B2 and watching B5 respond is the quickest way to decide whether a one-off top-up is worth making.
What should you do after the first month?
- Update B2 with the actual amount saved, not the planned amount.
- Check whether the monthly figure in B5 has moved. If it creeps up, you are behind.
- Keep one row per goal if you have several, and total the monthly column to see the real commitment.
If you track spending in SpendixAI, savings goals sit alongside budgets on the Pro plan, so the same place that shows your monthly spend can show how a goal is going. The sheet above is enough to start, and it teaches you what the numbers mean.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


