Content Calendar

About this template

What each of the three sheets does

Use this when you need a month of publishing dates, with owner and workflow stage, on one page. The sheets are the monthly calendar, the schedule list and the rollup, and only the schedule list takes typed data. The other two either count it (rollup) or hold a hand-copied view of it (calendar). The four boxes across E5:H5 of the calendar – registered, done, active, planned – and the per-category counts on the rollup sheet are all formulas, so an accurate list fills them by itself. The note on the first sheet says it plainly: never type over the total and average cells, they are formulas.

Start with the schedule list

1. In rows 7-26, from column B rightwards, enter No, date, weekday, title, category, owner, workflow stage and status. The weekday in column D fills itself from the date. The file ships with 14 rows covering 1-29 June 2026 in rows 7-20; rows 21-26 keep only their numbers and the weekday formula.
2. Category (column F) must be one of the four legend names – blog post, video clip, newsletter, general operations – typed as the name only, without the symbol. The defaults are 4, 4, 3 and 3.
3. Status (column I) takes three words only: done, active, planned. The defaults are 4 / 3 / 7, which makes the completion rate read 29%.
4. Column G cycles through four owners and column H uses only three workflow stages – keyword selection, image production, scheduled publishing. There is no channel column anywhere. The rollup sheet is titled as a category and channel rollup, but it only aggregates categories, so add a column yourself if you track channels.
5. Copy only confirmed items into the calendar grid under the day number, prefixed with the legend symbol, and put issues in the memo column of the five weekly rows (week 1, 1-7 June, through week 5, 29-30 June). The legend marks Saturday and Sunday as non-working, and no default row falls on a weekend.
6. On the rollup sheet, fill plan and actual in the plan-versus-actual table, and write current status in the blank cells beside the four monthly targets: 12 posts a month, 4 channels, a 32% email open rate, and a fixed Tuesday 08:00 send.

Rows that ship in the file

• 8 June, scheduled publishing, newsletter, Kim Haneul, image production, active – copied into day 8 of the grid with the newsletter symbol.
• 17 June, newsletter, general operations, Kim Haneul, scheduled publishing, planned – copied into cell D17, the 17th, with the general-operations symbol.
• The events row of the plan-versus-actual table: plan 26, actual 18, attainment 69%. The four-row total is 54 against 78, also 69%.
• The grid symbol follows the category, not the title. The 15 June item is titled video clip but is categorised as newsletter, so the grid shows it with the newsletter symbol. Pick the symbol from column F when you copy rows over.
• Keep titles short. Column E is about 22 characters wide and the grid cells are narrower, so long titles are cut on both sides. Move standards and sending rules into the weekly memo.

How the formulas work

• Weekday: =IF(C7=””,””,CHOOSE(WEEKDAY(C7,2),…)) returning the Korean day names.
• Registered count on the calendar: =COUNTA(‘schedule list’!E7:E26)&”items”; the done box is =COUNTIF(‘schedule list’!I7:I26,”done”)&”items”, with the same shape for active and planned.
• Completion rate in D31 of the list: =COUNTIF(I7:I26,”done”)/MAX(1,COUNTA(I7:I26)), so an empty list never divides by zero.
• Category counts: =COUNTIF(‘schedule list’!F7:F26,”blog post”) – one character of difference from the legend gives zero. The share beside it divides by the sum of the four counts and stays blank when that sum is zero, and the wide column to its right is the distribution bar the sheet note refers to.
• First and last dates use =MIN(C7:C26) and =MAX(C7:C26), so the dates must be real date values.
• Attainment: =IF(C15=0,””,D15/C15) – leaving the plan blank returns an empty cell rather than an error.

Why the rollup reads zero

• Entering a date as text such as 6/3; the weekday errors out and the first/last dates drift. Column C holds real dates in yyyy-mm-dd format.
• Writing a longer word instead of the exact status, or prefixing the category with its symbol. COUNTIF matches exact strings, so the cards fall to zero. Symbols belong only in the legend and the calendar grid.
• Continuing below row 27: the ranges stop at 26. The note under the list says to add rows and widen the formula ranges together.
• One word used for two things: the category column in the list means blog post, video clip, newsletter or general operations, while the plan-versus-actual table on the rollup sheet uses new product, how-to, interview and event, which are topics. Rename that lower header to topic so it is not confused with the category table above it.
• Reusing the file next month by editing only the day numbers, the week labels and the June 2026 title; if last month’s rows stay in the list, the rollup counts two months at once.