How to Populate an Excel Calendar with Multiple Symptoms per Date in WPS Office
Question details
The user needs to populate an Excel calendar so that one date can show multiple symptom entries, using a formula that matches the chosen calendar layout.

- Product
- WPS Office Excel
- Device & OS
- not provided
- Scenario
- Creating a calendar report that displays all symptom entries for each date, with a weekly, monthly, or other layout.
- Observed behavior
- The required formula depends on the chosen calendar layout; a single date must display multiple matching symptom entries.
Decide whether the report will use a weekly, monthly, or other calendar view, and check that your WPS Office Excel version supports dynamic array functions such as FILTER and TEXTJOIN before entering formulas.
Create a Date-Specific Symptom List with FILTER and TEXTJOIN
Use this when you want every symptom for a selected date to appear in one calendar cell, especially in WPS Office Excel or Excel 365 with dynamic array support.
FILTER returns all symptom entries matching the selected date. Wrapping it with TEXTJOIN and CHAR(10) places each symptom on a new line inside the same cell.
Open the WPS Office Excel workbook, confirm symptom entries are in one column and their dates are in an adjacent column, then select the calendar cell where the selected date is displayed.
In the calendar cell, enter =TEXTJOIN(CHAR(10),TRUE,FILTER(SymptomsRange,DateRange=SelectedDate,"")) and replace SymptomsRange, DateRange, and SelectedDate with your actual worksheet ranges and date cell.
Select the formula cell, go to the Home tab, and click Wrap Text so the line breaks created by CHAR(10) are visible.
Adjust the SelectedDate reference for each calendar date or use a structured date cell reference, then verify that the displayed symptoms match the source data.

Use a PivotTable for a Monthly Symptom Summary
Use this if you need a grouped date-by-date symptom review instead of placing all symptoms in one calendar cell.
Build a Multi-Symptom Calendar in WPS Office Excel
Use WPS Office Excel to create a calendar that lists all symptoms for each date in one cell. The built-in FILTER and TEXTJOIN formulas keep the workbook compatible with Microsoft Excel .xlsx files while producing a clean PDF export.
- 1. Download and open WPS Office Excel: Download WPS Office Free, open your workbook, and confirm dynamic array functions are available.
- 2. Set up symptom and date columns: Arrange symptoms in one column and matching dates in an adjacent column, then select the calendar date cell.
- 3. Enter the calendar formula: Type =TEXTJOIN(CHAR(10),TRUE,FILTER(SymptomsRange,DateRange=SelectedDate,"")) and replace the named placeholders with your actual range and date reference.
- 4. Enable Wrap Text and export: Click Wrap Text on the Home tab, set the print area if needed from the Page Layout tab, and export to PDF so line breaks remain visible.

Frequently Asked Questions
Which formula puts multiple symptom entries into one Excel calendar cell?
Use =TEXTJOIN(CHAR(10),TRUE,FILTER(SymptomsRange,DateRange=SelectedDate,"")) in WPS Office Excel. Replace SymptomsRange with the symptom column, DateRange with the date column, and SelectedDate with the calendar date cell, then enable Wrap Text.
Why do my symptoms appear in one long line instead of separate lines?
The formula inserts line breaks with CHAR(10), but they are only visible after selecting the cell and enabling Wrap Text from the Home tab.
Can I use this formula if my workbook opens in Microsoft Excel?
Yes. WPS Office Excel supports .xlsx files, and the FILTER and TEXTJOIN formula works in Excel 365. Older Excel versions may require an array-entered alternative or a manual helper layout.
How can I export the populated calendar to PDF without cutting off symptom text?
Enable Wrap Text, adjust row heights, set the print area from the Page Layout tab, and then export or print to PDF.




