Money tips

See your weekend spending spikes before the month total hides them

Monthly totals hide weekend and festival spikes. Tag each transaction by day type and compare weekday and weekend spend per day, with a formula.

Editorial illustration for See your weekend spending spikes before the month total hides them

Weekend spending spikes are invisible in a monthly total because the total adds all days together. To see them, tag every transaction as weekday or weekend by its date, total each group and divide by the number of days in that group. Comparing spend per day is the fair test, since a month has more weekdays than weekend days.

Why do monthly totals miss it?

A monthly figure tells you what happened, not when. Two people can both spend ₹21,600, one steadily and the other with a heavy weekend, and the total looks the same. Festivals add another layer: a long weekend with Diwali or Eid in it can double the usual outing spend without any weekly habit changing.

How do you tag weekends in a spreadsheet?

Put dates in column A and amounts in column C. In D2 add a helper column using a formula that works in Excel and Google Sheets:

  • =IF(WEEKDAY(A2,2)>5,"Weekend","Weekday")
  • WEEKDAY with 2 as the second argument counts Monday as 1 and Sunday as 7, so anything above 5 is Saturday or Sunday.
  • Weekend total: =SUMIFS($C$2:$C$500,$D$2:$D$500,"Weekend")
  • Weekday total: =SUMIFS($C$2:$C$500,$D$2:$D$500,"Weekday")

Fill the helper formula down the whole column, and keep the range the same size as your data.

A worked example with made-up numbers

Say in a 30-day month there are 22 weekdays and 8 weekend days. Weekday spending is ₹14,400 and weekend spending is ₹7,200.

GroupSpendDaysPer day
Weekdays₹14,40022about ₹655
Weekend days₹7,2008₹900
Month₹21,60030₹720

Weekend days cost about ₹245 more per day than weekdays: 900 minus 655. The weekend share of spending is 7,200 / 21,600, which is a third, from just over a quarter of the days.

How do you tag festival days?

Make a short list of festival and long-weekend dates for the year and add a second helper column that checks against it. In Excel 365 or Google Sheets: =IF(COUNTIF($H$2:$H$30,A2)>0,"Festival",D2), where H2:H30 holds your festival dates. This overrides the weekday label on those dates, and you can total the three groups the same way.

What do you look for in the result?

  • Which categories drive the weekend rise: food delivery, travel, shopping or entertainment?
  • Is it every weekend or only the first one after payday?
  • How much of the rise is fixed, like a weekly family outing you value?

Spending you enjoy and choose is not a leak. The aim is to see it, not to remove it.

How do you read the result without guilt?

Say your weekend figure is ₹900 a day and your weekday figure is ₹655. Ask what the extra ₹245 buys. If it is a family meal and a film that everyone looks forward to, you may decide it is money well spent and adjust something else. If it is delivery orders you barely remember, that is a different conversation.

A useful test is to look at the three largest weekend transactions in the month and ask whether you would choose them again. Two out of three is a fine answer. Make one small change at a time, such as a weekend cap for one category, and look again after a month.

When a sheet stops being enough

If you track a few hundred rows a month, a helper column is fine. Once you import bank and card statements regularly, SpendixAI's Report builder lets you filter and group by date range and category and download CSV, so you can compare weekend and weekday spend without copying formulas.

Next steps

  1. Tag one month of transactions.
  2. Compare per-day figures.
  3. Pick one weekend category to watch next month.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports