I have a sheet that uses Gantt chart data to show assignments on a calendar.

The persons assigned are all in a "Name" column that is a drop down with all the employee names on them. Next to that are start and end date columns that then show a bar range in calendar view.

The employee's name will only