How to Create an Excel Calendar That Displays Events by Date
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.

- 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.
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.
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.
Enter event dates in one column and event descriptions in the next column. Select the data, click Insert > Table, and name the table Table1.
Type a year in one cell and a month in another cell. These cells will drive the calendar dates.
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.
In the first date cell, enter =TEXTJOIN(", ",TRUE,FILTER(Table1[Event],Table1[Date]=A1,"")) where A1 is the calendar date cell.
Fill the formula into all date cells. Each cell displays the matching events, and dates with multiple events show them separated by commas.

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. 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. 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. 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. Fill the calendar grid: Copy the formula across all date cells to display matching events for each day.
- 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.

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.




