Function Problems

How to Create an Excel Calendar That Displays Events by Date

Muhammad TalhaMuhammad Talha Nov 13, 2026 869 views

Question details

The user wants to build a calendar on a new Excel worksheet that retrieves events from a separate data range or Excel table and displays them under the correct dates, including multiple events on the same date, using formulas instead of VBA.

How to Create an Excel Calendar That Displays Events by Date
Product
WPS Spreadsheets / Microsoft Excel
Device & OS
not provided
Scenario
The user maintains event data in a separate range or table and needs a monthly calendar view that automatically shows each event on its matching date.
Observed behavior
The calendar should display all matching events in each date cell and combine multiple events on the same date without using VBA.
Before you start

Organize your event data in a table or range with one column for dates and one column for event descriptions. Make sure the date column contains real Excel date values rather than text so FILTER comparisons work correctly.

Solution 1Recommended

Build a formula-based event calendar with DATE, FILTER, and TEXTJOIN

Use this method to create a calendar that automatically pulls events from a separate table and combines multiple events on the same date without VBA.

The calendar dates are generated from a selected year and month. Each calendar cell uses FILTER to find rows in the event table whose date equals that cell, and TEXTJOIN joins all matching event descriptions into one readable line.

Storing the event data as an Excel table, such as Table1, keeps the formula references stable as you add or remove events.

1
Set up the event table

Enter event dates in one column and event descriptions in the next column. Select the data, click Insert > Table, and name the table Table1.

2
Add year and month input cells

Type a year in one cell and a month in another cell. These cells will drive the calendar dates.

3
Generate calendar day cells

In the first calendar day cell, enter =DATE(year_cell, month_cell, 1). In the next day cell, enter =previous_day_cell+1 and fill across and down to create the monthly grid.

4
Enter the event lookup formula

In the first date cell, enter =TEXTJOIN(", ",TRUE,FILTER(Table1[Event],Table1[Date]=A1,"")) where A1 is the calendar date cell.

5
Copy the formula across the calendar

Fill the formula into all date cells. Each cell displays the matching events, and dates with multiple events show them separated by commas.

Build a formula-based event calendar with DATE, FILTER, and TEXTJOIN
Calendar updates automatically: When you change the year or month inputs or edit the event table, the calendar dates and displayed events update without VBA.
WPS Spreadsheets formula guide

Create an Event Calendar in WPS Spreadsheets Without VBA

Use WPS Spreadsheets to build a formula-driven Excel calendar that pulls events from a table using DATE, FILTER, and TEXTJOIN. It supports multiple events per date, updates automatically, and keeps your workbook compatible with Microsoft Excel files.

  1. 1. Open WPS Spreadsheets and create a workbook: Launch WPS Office, open WPS Spreadsheets, and create a blank workbook. Save it as an Excel-compatible .xlsx file.
  2. 2. Enter event data as an Excel table: Type your dates and event descriptions in two columns, select the range, and click Insert > Table. Name the table Table1.
  3. 3. Build the monthly calendar formula: Use DATE to generate each calendar date, then enter =TEXTJOIN(", ",TRUE,FILTER(Table1[Event],Table1[Date]=A1,"")) in the corresponding calendar cell.
  4. 4. Fill the calendar grid: Copy the formula across all date cells to display matching events for each day.
  5. 5. Change the year and month to update the calendar: Enter a new year and month in the input cells, and the calendar dates and events recalculate automatically.
Formula-only calendar that updates when event dates changeShows multiple events in one date cell with TEXTJOINNo VBA or macros required, so files remain easy to shareFully compatible with Microsoft Excel .xlsx workbooks
QA img-9

Frequently Asked Questions

Does this calendar require VBA or macros?

No. It uses DATE, FILTER, and TEXTJOIN formulas, so it works without VBA and remains easy to share.

How do I display multiple events on the same date?

Wrap FILTER inside TEXTJOIN. For example, =TEXTJOIN(", ",TRUE,FILTER(Table1[Event],Table1[Date]=A1,"")) combines all matching events into one cell.

Why should I store events in an Excel table?

An Excel table such as Table1 makes the date and event columns structured references that update automatically as you add rows.

Can I change the year and month after building the calendar?

Yes. Keep the year and month in input cells and base the calendar date formulas on them; changing the inputs updates the grid.

Is this compatible with WPS Spreadsheets and Microsoft Excel?

Yes. The formulas and .xlsx workbook format are supported in WPS Spreadsheets and Microsoft Excel versions that include FILTER and TEXTJOIN.