Using Index And Match To Return Potential Multiple Results To One Cell

I tried searching for posts, but received zero results. I'm not sure I was using the correct terminology.

In any case, a user is requesting that multiple absences in one day display on the calendar tab. Currently, I return one record per day. I'm assuming this may be a countif function, but am uncertain where to start. Any ideas?

Thanks!

JanAttendanceCard.xlsx

The calendar tab has an entire one year calendar that uses the index and match functions to find records and fill in the appropriate absence value under each date of the month, if there is a recorded absence. If a person came in late, then left early sick, or had some other combination of absences in one day, then we want to capture the values of both and display them in the calendar cell underneath the appropriate date of the month. The current array expression is: {IFERROR(IF([DATE]="","",INDEX(Overview,[ARRAY OF ABSENCES IN OVERVIEW WORKSHEET],MATCH(DATE(YEAR, MONTH,DATE),[SELECT ABSENCE CODE FROM OVERVIEW SHEET],[EXACT MATCH],[COLUMN 2],"")]. So, this returns only one value to the cell the expression is in. If there are multiple matches, I would like to return multiple values. I think it may have to do with a countif function, but I'm not sure.

For anyone selected from the drop down menu on the Overview tab (data source for calendar), the absence codes are displayed on the calendar tab under the respective dates of the year. If the employee had multiple absences for one date, then the code(s) would be displayed on the respective calendar date on the Calendar tab or a count of absences for that date would display on the calendar for the respective date(s).

So, selections are made on the Overview worksheet by selecting employee from the drop down and entering the correct reporting year. Then the codes display on the appropriate dates on the Calendar tab. We want to have some indication of multiple absence codes if there are multiple absences recorded for an employee for the same date.

Does this help?

Jan