Entering multiple events for same day using the Family Event Template in excel?

Thanks for sharing the details, Raymond!

The standard Family Event Template from Excel is designed to show only one event per date in the calendar view. If you want to make it show all three, try these:

• Use TEXTJOIN() or FILTER() in the formula cell so multiple events appear stacked in the same date box.
• Convert the calendar to a pivoted event list that groups events by day instead of a traditional calendar grid.

The first option only works for Excel 365 or Excel 2021, because older versions don’t have FILTER() or TEXTJOIN().

See if this helps. If you need further assistance just let me know.

Best regards,
Kimberly