TL;DR:
A content calendar is one sheet where every planned post has a date, a theme, an owner and a status.
Plan themes first, then fill dates, so posts support a purpose instead of filling gaps.
Two simple formulas, a count by status and a late check, tell you at a glance what needs attention.
It is Tuesday morning and you need to post something. You have no idea what, nothing is written, and no one knows who was supposed to do it. A content calendar fixes this by moving the decisions to a planning session once a month, so the daily work is just doing what the sheet says.
When a calendar helps
Use one if you post regularly for a business, a project, a club or yourself, and especially if more than one person is involved. Even a one-person calendar pays off, because it forces you to think ahead and gives you a record of what you have said.
Decide the basics first
Goal. What is the content for: telling people what you offer, teaching, staying in touch? One sentence.
Channels. Where you will post. Fewer channels done regularly beat many done rarely.
Rhythm. How often you can really keep up, for example two posts a week.
Themes. Three to five recurring topics that serve the goal.
People. Who writes, who reviews, who posts.
Building the sheet
Set the columns: A Post number, B Date, C Theme, D Topic or working title, E Status, F Owner, G Channel and H Notes or link to the draft.
Fill in the dates first: Put every posting day for the month in column B. Seeing the empty slots makes the real workload obvious.
Assign a theme to each slot: Rotate the themes so the month has variety, for example one how-to, one story, one question from a customer, one recap.
Write topics, then owners: Give each slot a specific working title and one named owner. A slot with no owner will not get done.
Use a fixed list of statuses: Idea, Drafting, Ready, Scheduled, Posted. Use a data validation dropdown on the Status column so spelling is always identical.
Worked example: a month of posts in one sheet
Say a small bakery plans November 2026 with posts every Tuesday and Thursday. November 2026 has Tuesdays on the 3rd, 10th, 17th and 24th, and Thursdays on the 5th, 12th, 19th and 26th, so there are 8 posts. All details are an example.
Date | Theme | Topic | Owner | Status |
|---|---|---|---|---|
Nov 3 | How-to | How to store sourdough | Ana | Posted |
Nov 5 | Behind the scenes | Early morning in the kitchen | Ben | Ready |
Nov 10 | Customer question | Can you make it gluten free? | Ana | Drafting |
Nov 12 | Recap | Bake sale numbers | Ben | Idea |
Nov 17 | How-to | Pairing bread with soup | Ana | Idea |
Nov 19 | Behind the scenes | Meet the new oven | Ben | Idea |
Nov 24 | Customer question | Do you take large orders? | Ana | Idea |
Nov 26 | Recap | Month in pictures | Ben | Idea |
Check the calendar: 4 Tuesdays + 4 Thursdays = 8 rows, and the four themes each appear twice, so the month is balanced. The dates are all real days of the week for that month.
Two formulas that do the watching
With dates in B2:B9 and statuses in E2:E9, count how many posts are in a given state. Put the status name in a cell such as H2 and use:
=COUNTIF($E$2:$E$9, H2)If H2 says Idea, the answer for the table above is 5. If it says Ready, it is 1. Add the counts for every status and the total should be 8: 1 Posted + 1 Ready + 1 Drafting + 5 Idea = 8.
To catch late posts, put this in I2 and fill down. It shows Late when the date has passed and the post is not marked Posted:
=IF(AND(B2<TODAY(), E2<>"Posted"), "Late", "")Suppose today is November 11. Row 2 (Nov 3) is Posted, so it stays blank. Row 3 (Nov 5) is only Ready, so it shows Late: it was never posted. Row 4 (Nov 10) is Drafting, so it also shows Late. The rest are in the future. That is a useful alarm, and it is also a prompt: either post the late items or move their dates.
Running it during the month
Hold a short planning session at the end of the month for the next one. Bring ideas, last month's results and any events coming up.
Work ahead by one week, so any post has time for a review before its date.
If you schedule posts in advance, change the status to Scheduled only once it is really set up in the tool you post with; our guide to scheduling social posts ahead of time covers that step.
After a post goes out, mark it Posted and paste the link in Notes so you can find it later.
Mistakes to avoid
A grid of dates with no themes. You will fill it with whatever is easy.
No owner on a slot, or an owner who does not know they are one.
Too many channels for the people you have.
Planning every single day. Leave a couple of open slots for news and timely things.
Never looking back. Note which posts people responded to and plan more like them.
Doing it faster
Duplicate last month's sheet, clear the topics and statuses and keep the dates, themes and formulas. If you want a partner to brainstorm topics with out loud while you look at the sheet, DuckyHelper can do that, though what you publish is up to you.
Frequently asked questions
How far ahead should I plan?
A month of themes and dates, with detailed drafts one to two weeks ahead, is enough for most small teams.
What if I run out of ideas?
Look at the questions customers or readers really ask you. Each one is a post, and the themes in your sheet give you a regular structure to fill.
Get started
