Weekend spending runs high because weekends hold the unplanned parts of life: eating out, shopping, outings, cabs and treats. To find the gap, split a month into weekdays and weekends, total each category, and divide by the number of days. Then set a weekend allowance, not only a monthly one.
How do I split a month into weekdays and weekends?
Take last month's payments with their dates. Mark each as a weekday or weekend. Here, weekend means Saturday and Sunday; if your Friday nights belong to the weekend, count them too. In a sheet with dates in column A and amounts in column C, this adds up the weekend rows: =SUMPRODUCT(--(WEEKDAY($A$2:$A$500, 2)>5), $C$2:$C$500). WEEKDAY with 2 numbers Monday as 1 and Sunday as 7, so anything above 5 is a Saturday or Sunday. This works in Excel and Google Sheets.
What might the gap look like?
Take a hypothetical 30-day month with 22 weekdays and 8 weekend days, and ₹18,000 of flexible spending:
| Category | Weekdays total (₹) | Weekend total (₹) | Per weekday (₹) | Per weekend day (₹) |
|---|---|---|---|---|
| Eating out | 1,800 | 3,200 | 82 | 400 |
| Shopping | 600 | 2,400 | 27 | 300 |
| Transport and cabs | 3,300 | 1,700 | 150 | 213 |
| Entertainment | 300 | 1,500 | 14 | 188 |
| Other | 2,800 | 400 | 127 | 50 |
| Total | 8,800 | 9,200 | 400 | 1,150 |
Check: weekdays 1,800 + 600 + 3,300 + 300 + 2,800 = 8,800, and 8,800 / 22 = ₹400. Weekends 3,200 + 2,400 + 1,700 + 1,500 + 400 = 9,200, and 9,200 / 8 = ₹1,150. The per-day figures are rounded.
Which categories cause the gap?
Compare the two per-day columns. A weekend day costs ₹1,150 against ₹400 on a weekday, a difference of ₹750 a day. Three categories explain most of it: eating out (₹400 against ₹82), shopping (₹300 against ₹27) and entertainment (₹188 against ₹14). Together their gap per day is roughly 318 + 273 + 174 = ₹765, which is slightly more than the full gap of ₹750 because the Other line costs ₹77 less per day on weekends, while transport is only ₹63 higher.
That is the useful insight: you do not need to cut weekends in general. You need to look at two or three categories on two days a week.
Should I set a weekend allowance?
If your weekends reliably cost more, a monthly limit hides the pattern. A weekend allowance makes it visible. Using the example above, the weekend total of ₹9,200 across 4 weekends is 9,200 / 4 = ₹2,300 per weekend. You could keep that number, or lower it to ₹2,000 and decide in advance which of the three categories gives way.
What if the weekend spending is not about habits?
Sometimes weekends cost more because they carry real needs: the weekly grocery run, family visits, errands you cannot do on a weekday. Look at what you bought before you decide anything. If a large share of the ₹9,200 is groceries and household items, the problem is not leisure, and the plan should treat those as regular costs.
In SpendixAI, categories on imported statements, plus cash you add by hand, let you filter a month and compare spend by category. Checking weekdays against weekends you can still do with a sheet formula, as above.
What to do next
- Mark last month's payments as weekday or weekend.
- Total each category for both groups, and divide by the number of days.
- Find the two or three categories with the biggest gap.
- Set a weekend allowance, and move it to its own balance on Friday.
- Compare again after a month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


