Free template

Every date that matters for 2027 sales, in one sheet

Black Friday, Mother's Day, Diwali, Christmas and 31 more key dates for 2027, each with the date you should start planning. Add your campaigns and see the whole year on one printable page.

Download the template Excel .xlsx · 58 KB · free, no signup
DateEventRegionLead timeStart planning
Sun 14 Feb 2027Valentine’s DayGlobal423 Jan 2027
Sun 7 Mar 2027Mother’s Day (UK)UK, Ireland4224 Jan 2027
Sun 9 May 2027Mother’s Day (US, Canada, Australia)US, Canada, Australia4228 Mar 2027
Fri 29 Oct 2027DiwaliIndia, global3524 Sep 2027
Fri 26 Nov 2027Black FridayGlobal561 Oct 2027
Mon 29 Nov 2027Cyber MondayGlobal564 Oct 2027
Six of the 35 built-in dates. Lead times are suggestions you can change. Start planning is the date minus the lead time.

What's inside

  • Key Dates. 35 dates for 2027: shopping events (Black Friday, Cyber Monday, Singles' Day, Boxing Day), gifting days (Valentine's, both Mother's Days, Father's Day, Christmas), public holidays in the US and UK, and cultural dates (Lunar New Year, Ramadan, Eid al-Fitr, Diwali, Hanukkah). Each one has its region, a suggested lead time and a planning start date. Add your own events underneath: launches, your store's birthday, local holidays.
  • Campaigns. One row per campaign with channel, dates, offer, budget and owner. It tells you which campaigns are running now, which start soon, and flags an end date before the start date.
  • Year at a Glance. All twelve months on one page, with key dates and campaign days coloured and today outlined. It prints on a single sheet.
  • Works for 2026 to 2030. Change the year on Settings and every date moves.

How the dates are worked out

Fixed dates like Halloween are the same every year. Holidays defined by a rule, like US Thanksgiving (the fourth Thursday of November), Memorial Day (the last Monday of May) or UK Mothering Sunday (three weeks before Easter), are calculated by formula. Easter itself uses the standard Gregorian Easter calculation. Every rule-based date was checked against an independent calculation for each year from 2026 to 2030.

Lunar New Year, Ramadan, Eid al-Fitr, Diwali and Hanukkah follow lunar calendars, so they come from a table of published dates: the Umm al-Qura calendar for Ramadan and Eid, Drik Panchang for Diwali and Hebcal for Hanukkah. Ramadan and Eid depend on moon sighting and can differ by a day from country to country, so they're marked approximate.

Start earlier than you think

The date on the calendar isn't the deadline. For gifting days, the real deadline is the last day a customer can order and still get delivery in time, and everything before that depends on stock, photos, emails and ad approval. That's why the suggested lead times are six to eight weeks for the big ones. A planning date in red means you should already be working on it.

Using it

  1. On Key Dates, set Show on calendar? to No for the dates your customers don't care about, and adjust the lead times.
  2. Add your campaigns on Campaigns, then delete the four samples.
  3. Print Year at a Glance and put it somewhere you'll see it.

In Google Sheets: upload to Drive, right-click → Open with → Google Sheets, then File → Save as Google Sheets.

Related reading

Marketing Calendar 2027

Excel .xlsx · 58 KB · Works with Google Sheets, Excel and LibreOffice

Download