To turn a wishlist item into a monthly saving amount, subtract what you have already set aside from the price, then divide by the number of months until your target date. A ₹60,000 laptop with ₹6,000 saved and nine months to go needs ₹6,000 a month.
The formula
Put the price in B2, the amount already set aside in C2 and the target date in D2. Then:
- =DATEDIF(TODAY(),D2,"m") in E2 counts the whole months from today to the target date.
- =IF(E2<1,"date has passed",ROUNDUP((B2-C2)/E2,0)) in F2 gives the monthly amount, rounded up to the next rupee.
- =SUM(F2:F4) at the bottom adds up what all your goals need together each month.
DATEDIF works in Excel and Google Sheets. It counts complete months, so if the target is a month and a half away it counts one. That makes the monthly amount slightly higher, which is safer than falling short. The formula ignores any interest your savings might earn and does not allow for the price changing.
Three made-up items
| Item | Price | Set aside | Months left | Monthly amount |
|---|---|---|---|---|
| Laptop | ₹60,000 | ₹6,000 | 9 | ₹6,000 |
| Washing machine | ₹28,500 | ₹0 | 6 | ₹4,750 |
| Sofa | ₹36,000 | ₹4,000 | 8 | ₹4,000 |
| All three | ₹1,24,500 | ₹10,000 | n/a | ₹14,750 |
The laptop needs 54,000 more (60,000 minus 6,000), divided by 9, which is 6,000. The washing machine needs 28,500 over 6 months, which is 4,750. The sofa needs 32,000 over 8 months, which is 4,000. Together that is ₹14,750 a month, which may be more than your free cash, so check the total before committing.
What if the total is too much?
Compare the combined monthly figure with what is actually left after rent, bills and EMIs. If it does not fit, you have three levers: move a target date later, lower the price by choosing a simpler model, or drop one goal. Pushing the sofa from 8 to 14 months turns its ₹4,000 into about ₹2,286 a month (32,000 divided by 14), which frees ₹1,714 for the other goals.
Where should the money sit?
Money for a goal is easiest to keep when it does not sit with your daily spending. A separate account or a separate named pot works. Choose where you keep it according to when you need it: a short goal needs access, and what you do with longer ones is a personal decision beyond this article. Move the monthly amount on salary day, the same way you would pay a bill.
Entering the goal in a tracker
SpendixAI's Pro plan includes budgets, bills and savings goals, so a goal can be entered with its name, target amount and date and checked against your actual month. The formula above is still useful for deciding the figure before you enter it. If your tracker shows a different monthly figure, compare the assumptions before trusting either.
What if your income varies?
Work from the lowest month in your recent history, not the average. If the goal needs ₹6,000 a month and some months bring in much less, the plan will break in exactly those months. Choose a smaller regular amount and add the rest in good months. Update the set-aside column each time so the formula recalculates from the real balance.
A short checklist
- Write the current price and date of the price.
- Enter how much is already set aside.
- Pick a target date that matches a real need, such as a festival or a move.
- Work out the monthly amount and check it against your free cash.
- Set a transfer for the same day each month.
At the end of each month, update the set-aside column with the real amount and the months left. Within a quarter you will know whether the plan works or needs a new date.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

