Budgeting

Comparing this Diwali with last Diwali when the dates move

Compare festival spending year over year with a festival-aligned 30-day window instead of the calendar month, so a moving Diwali date does not distort the result.

Editorial illustration for Comparing this Diwali with last Diwali when the dates move

To compare this Diwali with last Diwali fairly, ignore calendar months and measure the same 30-day window around the festival day each year, say 21 days before it to 8 days after. Because the festival moves between October and November, comparing October with October can make a normal year look like a 60% jump. Here is the method with hypothetical totals.

Why does the calendar month mislead?

Festival spending does not wait for the day itself. Shopping, sweets, gifts, cleaning and travel build for two to three weeks beforehand and trail off after. If the festival fell in the first week of November last year and in the second half of October this year, October contains almost all the build-up this year but only the early part last year. The months are not comparable even though both are named October.

Suppose October last year totalled ₹38,000 and October this year ₹61,000. The raw change is ₹23,000, which is about 61% more. Hold that number loosely for now.

How do you build a festival-aligned window?

  1. Note the festival day for each year, for example Diwali day itself.
  2. Choose the same offsets both times: start 21 days before and end 8 days after, which is 30 days counting the festival day.
  3. Total every purchase in that window, by category.
  4. Do the same for a normal 30-day stretch in a quiet month so you know the baseline.

In a sheet, put the festival date in $F$1 and sum the window with =SUMIFS($C$2:$C$2000, $A$2:$A$2000, ">="&($F$1-21), $A$2:$A$2000, "<="&($F$1+8)) where column A holds dates and column C holds amounts. Change $F$1 to last year's date and the same formula gives last year's window. Dates must be real dates, not text.

What does the comparison look like with real categories?

CategoryLast year's windowThis year's windowChange
Gifts and sweets₹12,000₹14,000+₹2,000
Clothing₹18,000₹17,500-₹500
Decor and cleaning₹6,000₹8,500+₹2,500
Travel₹10,000₹12,000+₹2,000
Groceries and festival food₹14,000₹15,500+₹1,500
Everything else₹8,000₹7,000-₹1,000
Total₹68,000₹74,500+₹6,500

On aligned windows the festival cost ₹6,500 more, which is about 9.6% (₹6,500 ÷ ₹68,000). That is a very different story from the 61% the calendar months suggested.

Should you compare against a normal month too?

Yes. Say a quiet 30-day period costs ₹44,000 for you. Then the festival added ₹30,500 on top of normal this year (₹74,500 minus ₹44,000) and ₹24,000 last year (₹68,000 minus ₹44,000). Comparing the extra amounts shows the festival's own cost without the rent and groceries you would have paid anyway. If your baseline changed between years because of a raise or a move, use each year's own baseline.

What do you do with the result?

Start with the line that moved most relative to its size. In the table, gifts and sweets rose about 17% (₹2,000 on ₹12,000) while decor and cleaning rose about 42% (₹2,500 on ₹6,000), so decor deserves the first question even though the rupee changes look similar.

Use it to set next year's festival envelope, with the same offsets applied to next year's date. If gifts rose ₹2,000 because the list grew, that is a decision. If decor and cleaning rose ₹2,500, check whether that was a one-time repair or repainting. The same method works for any moving date, such as Eid, Onam, Pongal or a wedding season, as long as you count the same days either side.

  • Write the festival date and the offsets on the first row of your sheet so you do not have to remember them.
  • Keep a note of any gifts you paid in cash, since they will be missing from a statement.

With your statements imported into SpendixAI, a report with your own date range per year gives each window total by category without hand-adding.

SPENDIXAI JOURNAL

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

Explore your reports