Build a Content Calendar in Excel

A content calendar in Excel is a list of planned posts, one row each, with the date, channel, topic, owner and status. Add a few formulas and colour rules and it tells you what's due this week, what's late and how busy each channel is. This guide builds one step by step, for marketers, small business owners and anyone who plans social posts, blogs or newsletters.

Plan the columns first#

Start with a list, not a calendar grid. A list with one row per post can be sorted, filtered and counted; a grid of boxes can't. Here's a solid set of columns:

Select your headers and data and press Ctrl+T (Mac: ⌘T) to turn it into an Excel table. Tables add filter buttons, keep formatting consistent and copy formulas down to new rows by themselves. Freeze the header row with View > Freeze Panes > Freeze Top Row so it stays visible as the list grows.

Enter dates and show the day name#

Type dates in a format Excel recognises, such as 2026-11-03 or 3 Nov 2026, so they're stored as real dates. Then show the weekday next to each one:

=TEXT(A2,"ddd")

For 3 November 2026 this returns Tue. Use "dddd" for the full name, Tuesday. Keeping the date and the day in separate columns means you can still sort by date. The guide to getting the day name from a date shows more formats, and you can practise date basics in a live sheet.

Real dates matter because every formula below compares them. If a date is stuck as text, it won't sort, count or colour correctly.

Fill repeating dates automatically#

Most calendars have a rhythm, like a LinkedIn post every Thursday or a newsletter each month. Let formulas create the dates:

EDATE moves a date by whole months and handles short months for you. EOMONTH returns the last day of a month, and WORKDAY steps back to a weekday if that day falls on a weekend. For November 2026, the last formula returns Mon 30 Nov. The EDATE, EOMONTH and WEEKDAY lesson practises all three.

If a post later gets a fixed date, paste it as a value or type over the formula, so changing the first date doesn't move it.

Add a status drop-down#

A drop-down keeps status values consistent, which matters because your counts depend on exact text. "Published" and "published " (with a space) are different to a formula.

1. Select the Status cells, for example F2:F200.
2. Go to Data > Data Validation.
3. Under Allow, choose List.
4. In Source, type Idea,Drafting,Scheduled,Published.
5. Click OK.

Do the same for Channel and Owner if you have a fixed list.

Colour weekends and overdue posts#

Conditional formatting colours cells by rule, so problems stand out without anyone checking line by line. Select the data rows (say A2:G200), go to Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format, and add these rules:

WEEKDAY($A2,2) numbers Monday as 1 and Sunday as 7, so anything above 5 is Saturday or Sunday. TODAY returns the current date and updates every day, so the overdue colour moves on its own; see the TODAY function guide. The $ before A and F locks the column, so every cell in the row checks the same date and status.

The conditional formatting lesson walks through formula rules, and the guides to highlighting weekends and conditional formatting cover more patterns.

Count posts by channel and month#

A small summary shows whether a channel is overloaded or empty. Put the first day of a month in I1, like 1 Nov 2026, and the channel names down I3:I5. Then in J3:

=COUNTIFS($C$2:$C$200,I3,$A$2:$A$200,">="&$I$1,$A$2:$A$200,"<="&EOMONTH($I$1,0))

This counts rows where the channel matches I3 and the date falls between the first and last day of that month. Fill it down for each channel. Change I1 to another month and the whole summary updates. To count by status instead, swap the channel column for the status column. The COUNTIFS function guide explains the criteria pairs.

In the exercise on this page, three LinkedIn posts fall in November 2026: 3, 12 and 26 November. The October and December posts are left out by the date limits.

List this week's posts with FILTER#

FILTER pulls matching rows into a separate list that updates by itself, perfect for a "This week" panel at the top of the sheet:

=FILTER(A2:F200,(A2:A200>=TODAY())*(A2:A200<TODAY()+7),"Nothing scheduled")

The * between the two conditions means AND: the date is today or later, and less than seven days away. FILTER needs Excel 2021 or Microsoft 365; in older versions, use the table's filter buttons with a date filter instead. See the FILTER function guide.

If your calendar is part of a bigger plan with phases and deadlines, the guide to building a project timeline shows a Gantt-style view, and the article on Excel skills for marketing jobs covers what else marketing roles expect.

Practise it#

A content calendar is mostly date formulas plus a few rules. Practise EDATE, EOMONTH and WEEKDAY in a live spreadsheet: you move dates by months, find month ends and check weekdays, and each formula is checked instantly. Then try the conditional formatting lesson to colour overdue posts, and the exercise on this page to count a month's LinkedIn posts.