Take the last 30 days of spending, remove anything that only happens once a year or once on a trip, add back a daily share of the yearly items, and divide by 30. That rolling figure is steadier than a calendar-month average and does not jump on the first of the month when the counter resets.
Why does a calendar month mislead?
A calendar month restarts at zero on the 1st, so on the 2nd you have almost no data and on the 31st you have a full picture. Months also differ in length, and annual payments land in one month and vanish from the next. A rolling window of 30 days always contains a full cycle of paydays, groceries and bills, so each day's figure is comparable with yesterday's.
A worked example
Say the last 30 days of spending add up to €1,650. Inside that total are two items that do not belong in an everyday figure: an annual contents-insurance payment of €438 and a one-off flight of €210.
| Step | Working | Result |
|---|---|---|
| Everyday spending | €1,650 - €438 - €210 | €1,002 |
| Everyday average per day | €1,002 / 30 | €33.40 |
| Daily share of the annual insurance | €438 / 365 | €1.20 |
| Everyday figure including the insurance share | €33.40 + €1.20 | €34.60 |
| Trip kept separate | The flight of €210 belongs to a travel total | €210 |
So your ordinary day costs about €34.60, and the flight sits in its own line where you can judge the trip as a trip.
What do I do with once-a-year bills?
Divide the amount by 365 and add that to the daily figure, as above, or divide by 12 if you prefer a monthly sinking amount. Either way you are paying yourself in advance, so the cost does not arrive as a shock. List your yearly items once: insurance, annual subscriptions, a car or bike service, a membership. Add them up, and divide the total by 365.
Can I build the rolling window in a sheet?
Put dates in column A, amounts in column C and a label in column D such as Everyday, Annual or Trip. The 30-day everyday total is:
=SUMIFS($C$2:$C$500,$A$2:$A$500,">"&TODAY()-30,$A$2:$A$500,"<="&TODAY(),$D$2:$D$500,"Everyday")
Divide that cell by 30. Excel and Google Sheets both accept the criteria written this way, joining the operator and the date with an ampersand. Check that your dates are real dates, not text, or the comparison will return zero.
How often should I recalculate?
- Weekly is enough for most people, because the window moves slowly.
- After any large change: a new flat, a new job pattern, a child starting nursery.
- After a trip, once the trip costs have been tagged and removed.
- When the figure drifts more than a few euros from last month: find the category that grew.
Does trip spending belong in the average?
Not in the everyday average, but it deserves a figure of its own. Count the days away and divide the trip's total by them. If the €210 flight is part of a 6-day break that also cost €390 on the ground, the trip is €600 in total, or €100 a day. Comparing €100 with €34.60 shows plainly how much a holiday day costs relative to home.
Before you rely on the number
- Check that every account is included, or you will understate the average.
- Confirm that transfers between your own accounts are excluded.
- Label annual and trip items before you divide.
- Write the figure down with the date, so next month you can compare like with like.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

