A UK wedding checklist in Excel or Google Sheets

A checklist that dates itself. Type your wedding date once and every task gets its due date.

Updated 18 October 2026 · You & Evermore

Prefer a spreadsheet? Our UK Wedding Planner Spreadsheet works in Google Sheets and Excel (on Etsy).

The trick: weeks before the day

Don't type a due date for each task. Give each one a number of weeks before the wedding, and a negative number for after. Then one formula dates them all: due date = wedding date minus weeks times seven.

Weeks beforeTask
52Book the venue and pay the deposit
52Buy wedding insurance
13Give notice of marriage (England and Wales: at least 29 days, at most 12 months before)
6Final numbers and seating plan to the venue
-2Send thank-you cards

Columns

Two rules that help

The full 39-task list is on our UK wedding planning checklist page, free to print. Our UK Wedding Planner Spreadsheet has it built in. Its dashboard shows the next five tasks.

Build it in five minutes

  1. Put your wedding date in one cell at the top, say B1.
  2. In row 3 type the headings: Weeks before, Task, Who, Due date, Done, Status.
  3. Type each task with its number of weeks before the wedding.
  4. In Due date: =$B$1-A4*7, then copy it down. The dollar signs keep every row pointing at the wedding date.
  5. Format the Due date column as a date, and Done as a tick box. In Google Sheets use Insert > Checkbox; in Excel, a drop-down with Yes is simplest.

The Status column

A formula like =IF(E4=TRUE,"Done",IF(D4<TODAY(),"Late",IF(D4-TODAY()<=7,"This week",""))) labels every task in Google Sheets. With the Excel drop-down, test for Yes instead: =IF(E4="Yes","Done",IF(D4<TODAY(),"Late",IF(D4-TODAY()<=7,"This week",""))). Sort or filter on it and you have this week's to-do list without retyping anything.

Splitting the work

The Who column is what turns a checklist into a plan for two. Go through it together once and give every task an owner. Filter to your own name when you sit down to do some. Tasks marked Both are ones you do together, like choosing the venue. Writing the guest list is another.

The UK dates to get right

Two dates are fixed by rules rather than taste. In England and Wales you give notice of marriage at least 29 days before the wedding. It can be no more than 12 months before. Place it in the checklist with room to book an appointment. Your venue's contract will say when it needs final numbers and the seating plan. Our checklist puts it at six weeks. Replace that with your venue's own date.

Adding your own tasks

Every wedding has tasks no template knows about. A dress from abroad, a family tradition, a ceilidh caller. Add them as new rows with their own weeks-before number. They slot into date order with the rest. If a task depends on another, give it a smaller number so it falls after. For example, the seating plan comes after the replies are in.

Keep the list as one sheet, not one per month. Sorting by due date does the grouping, and nothing gets lost between tabs.

Sources

Rules and fees change; always check with your register office or venue.

Questions

How do I make due dates update from the wedding date?

Store each task as weeks before the day, then use: wedding date minus weeks times seven. Change the date and every task moves.

When should notice of marriage go on the checklist?

In England and Wales, notice is given at least 29 days before the wedding. It can be no more than 12 months before. Place it with time to book an appointment.

Plan it all in one shared place

Our Notion planners are made for UK weddings. They cover a budget in pounds, day and evening guests and notice of marriage. The planning checklist dates itself from your wedding day. Launch sale: 35% off until 1 December.

UK Wedding Planner, £14.82 on EtsyGet the free planner

Related guides

The UK wedding planning checklistNotice of marriage in the UK