Business

Best and worst weekday for your shop: reading it from daily sales

Find the best weekday for sales in your shop by averaging four weeks of daily sheets, then spot the weak day and try low-cost fixes.

Editorial illustration for Best and worst weekday for your shop: reading it from daily sales

To find your best and worst weekday, take four weeks of daily sales, group the figures by day of the week, and average each group. The weekday with the lowest average is your weak day, and the highest is your strongest. Four weeks is a minimum, since any single day can be thrown off by weather, a festival or a holiday.

How do I set up the data?

List 28 days in order, with the date in A and the day's total sales in B. In C, put the weekday number for each date: =WEEKDAY(A2,2). With that setting, Monday is 1 and Sunday is 7. The averages then come from one formula per weekday, for example for Tuesday: =AVERAGEIFS($B$2:$B$29,$C$2:$C$29,2).

Alternatively, use a pivot table with the weekday as rows and the average of sales as values. Either way works in Excel and in Google Sheets.

A made-up grocery shop, four weeks

WeekdayFour-week totalAverage per day
Monday₹56,000₹14,000
Tuesday₹48,000₹12,000
Wednesday₹52,000₹13,000
Thursday₹50,000₹12,500
Friday₹60,000₹15,000
Saturday₹80,000₹20,000
Sunday₹64,000₹16,000

Each average is the total divided by four: 56,000 divided by 4 is 14,000, and so on. Saturday is the best day at ₹20,000, and Tuesday the weakest at ₹12,000. The gap is ₹8,000, which is 40% of Saturday's average.

Is the weak day really weak?

Before you act, test it.

  • Did a festival, rain, a local strike or a bank holiday fall on one of the four days? If so, leave that day out and average the rest, or add a fifth week.
  • Is the weak day the same in all four weeks, or did one week drag the average down? Look at each week's figure side by side.
  • Does the weak day follow a high day? Sales sometimes shift because customers stocked up the day before.
  • Is it weak in sales but strong in margin? Check before you treat it as a problem.

What can I do about a weak day?

Start with low-cost changes, and try one at a time so you can see what worked.

Here is how to test shorter hours with made-up numbers. Say Tuesday's last hour brings ₹350 of sales on average. At a 20% margin, that is ₹70 of gross profit. If keeping a helper and the lights on for that hour costs ₹120, closing an hour earlier saves ₹50 a Tuesday, about ₹200 a month. If the hour's sales were ₹900 instead, the gross profit of ₹180 would beat the ₹120 cost and you should stay open.

  1. Shorter hours: if the first or last hours of Tuesday bring almost nothing, open later or close earlier and see whether sales change. Check the sums first: hours saved against sales given up.
  2. A small promotion: a modest offer on a few regular items for that day only, funded within your margin. Do not discount below your cost.
  3. Restocking day: schedule deliveries, shelf work and cleaning on the quiet day, so busy days are for selling.
  4. Tell regulars: a message to the people you already know, about a day when you can help them without a queue.

How often should I repeat this?

Every quarter, or when something changes: a new shop opens near you, a school term starts, a market day moves. Keep the old tables, because the way a pattern shifts over the year is part of knowing your shop.

A quick checklist

  • Four full weeks, with unusual days marked.
  • Weekday averages, lowest and highest named.
  • The gap between them as a rupee amount and a share.
  • One change tried for four weeks, and the result compared.
SPENDIXAI JOURNAL

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

Explore your reports