Your weekend spend share is weekend spending divided by total spending, and you need to set it against the share of days to read it. If weekends are about 29% of the days in a month and 30% of the spend, you spend almost the same per day on weekends as on weekdays.
The formula, step by step
- Total spending for the month.
- Weekend spending: Saturday and Sunday only.
- Weekend share = weekend spending ÷ total spending.
- Per-day averages: weekend spending ÷ weekend days, and weekday spending ÷ weekday days.
A worked example
Say a four-week month has 28 days: 8 weekend days and 20 weekdays. Total spending is ₹48,000, of which ₹14,400 was on weekends.
| Measure | Calculation | Result |
|---|---|---|
| Weekend share of spend | 14,400 ÷ 48,000 | 30% |
| Weekend share of days | 8 ÷ 28 | About 29% |
| Weekday spend | 48,000 - 14,400 | ₹33,600 |
| Weekend per day | 14,400 ÷ 8 | ₹1,800 |
| Weekday per day | 33,600 ÷ 20 | ₹1,680 |
| Weekend premium | (1,800 - 1,680) ÷ 1,680 | About 7% |
A 30% share on 29% of the days is close to flat. The person spends ₹120 a day more on weekends, which is not a big shift. The share on its own can sound alarming; set against days, it is quite ordinary.
How do you do it in a spreadsheet?
Put dates in column A and amounts in C. In column D, mark each row: =IF(WEEKDAY(A2,2)>5,"Weekend","Weekday"). WEEKDAY with the second argument 2 numbers Monday as 1 and Sunday as 7, so 6 and 7 are the weekend. Then weekend spend is =SUMIFS($C$2:$C$500,$D$2:$D$500,"Weekend") and the share is that divided by =SUM($C$2:$C$500). To count weekend days in a month whose first day is in F1, use =DAY(EOMONTH(F1,0))-NETWORKDAYS(F1,EOMONTH(F1,0)), which is the days in the month minus the Monday-to-Friday days; it works in both Excel and Google Sheets, and ignores public holidays unless you add a holiday list. Weekday days are then the days in the month minus that count.
What should you take out first?
Bills and EMIs that fall on a particular date will land on a weekend by chance and distort the picture. If your ₹18,000 rent happened to be paid on a Saturday, the weekend share looks much higher than your habits justify. Compare using flexible spending only, or move such payments out before you calculate.
What does a higher weekend premium mean?
- A weekend per-day average far above the weekday one points to meals out, outings or shopping clustered on those days.
- A weekend average below the weekday one usually means work-related spending, such as commuting and office lunches, dominates the weekdays.
- If the premium swings month to month, it is events, not routine.
One month is a snapshot. Work out the numbers for three months and compare the weekend premium each time; a stable premium of a few per cent is your pattern, while a number that jumps around reflects what happened in each particular month.
Is this worth tracking?
It is a quick check, not a goal. If your weekend per-day number is close to the weekday number, you can stop worrying. If it is double, look at the categories on those days: dining out, entertainment, shopping. In SpendixAI you can filter by date range and category in the Report builder, and weekend days are simply the Saturdays and Sundays inside the range.
What if your month is not four weeks?
Most months have 30 or 31 days, so weekend days can be 8, 9 or 10. Always divide by the number of weekend days actually in that month. A five-weekend month with the same weekend spending as a four-weekend month has a lower per-day figure, and ignoring that will make the comparison between months look more changeable than it is.
A two-minute version
- Add up the month's total.
- Add up Saturday and Sunday spending.
- Divide, then divide again by days to get the per-day numbers.
- Write one line: share, share of days, premium.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


