To get twelve month headers from one cell, put a start date in B1 and type =EDATE($B$1,SEQUENCE(1,12,0)) in D3. Excel spills twelve month-start dates across the row, and formatting the cells as mmm-yy turns them into Apr-25, May-25 and so on. Change B1 and every header, and every total under it, moves with it.
How do the SEQUENCE and EDATE pieces fit together?
SEQUENCE(rows, columns, start, step) makes a block of numbers. SEQUENCE(1,12,0) is one row, twelve columns, starting at 0 and going up by 1: 0, 1, 2 up to 11. EDATE(date, months) returns the date that many months later, landing on the same day of the month. Give EDATE the array 0 to 11 and it returns twelve dates in one go.
- B1: 01-04-2025, a real date, not the text "Apr 2025". Right-aligned usually means it is a number; left-aligned usually means text.
- D3: =EDATE($B$1,SEQUENCE(1,12,0))
- Select D3:O3, then Format Cells, Custom, and type mmm-yy.
Because the start is the 1st, every header is a month-start date: 01-Apr, 01-May and so on. That keeps the SUMIFS below simple. This works in Excel 365 and 2021 because SEQUENCE needs dynamic arrays. If EDATE refuses the array in your build, this version does the same job: =DATE(YEAR($B$1),MONTH($B$1)+SEQUENCE(1,12,0),1).
How do I feed a SUMIFS grid from those headers?
Keep dates in A2:A500, categories in B2:B500 and amounts in C2:C500. Put category names in C4 downward (they can be typed or spilled) and write this in D4, then copy it across to O4 and down:
- =SUMIFS($C$2:$C$500,$B$2:$B$500,$C4,$A$2:$A$500,">="&D$3,$A$2:$A$500,"<"&EDATE(D$3,1))
Read it as: add the amounts where the category matches the label on the left, the date is on or after this month's header, and the date is before the next month's header. Using "before the next month" instead of "on or before the 30th" means months of 28, 30 or 31 days all work, and a transaction stamped late on the last day is not missed.
| Piece | What it does | Common slip |
|---|---|---|
| $C4 | Category label, column locked | Typing $C$4 stops the rows from changing |
| D$3 | Month header, row locked | Typing $D3 makes every month show the first month |
| ">="&D$3 | Start of the month | Forgetting the & joins nothing and returns 0 |
| EDATE(D$3,1) | Start of the next month | Using D$3+30 drifts off month boundaries |
How do I make it a financial-year view?
India's financial year runs April to March, so set B1 to 1 April. For FY 2025-26 that is 01-04-2025 and the twelve headers end at Mar-26. Next year, change B1 to 01-04-2026 and you have a new year view in seconds. Keep each year in its own copy of the sheet if you want to compare them side by side.
For a total column, use =SUM(D4:O4) in P4. For a total row, use =SUM(D4:D12) under each month. Say your Groceries for April is ₹9,200 and May ₹10,100; the first two cells show those, and P4 shows the full twelve months once the year is done.
A practical tip: keep the category names in C4 downward as a spilled list too, using =SORT(UNIQUE(FILTER($B$2:$B$500,$B$2:$B$500<>""))) in C4. Then a brand new category appears as a new row label. You still need to copy the D4 formula down to cover it, so leave a few spare formula rows and add a note when you run out.
What if the headers look like five-digit numbers?
Excel stores dates as serial numbers, so if you see 45748 instead of Apr-25, the cell format is General or Number. Apply the custom format mmm-yy. If the formula spills but only one cell shows, check that nothing sits in E3:O3, because that blocks the spill and gives #SPILL!.
Where does this stop being practical?
This grid depends on typed category labels and clean dates. If you paste statements every month, fixing text dates and renamed merchants becomes the real work. SpendixAI imports statements and shows category-by-month spending in its reports, which may suit you once the sheet needs weekly cleaning.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


