Trying to create a project calendar with project's start and end date for each individual

Hello Everyone,

Hope you are doing great!!

I am stuck with something that i would like to call a project calendar.

All i am trying to do in this query is to show the name of each project an individual is working on from its start date till the end date in the calendar.

Information on projects are available on Sheet 2 i.e. Project details.

I am creating a sample entry as per requirement manually for "Maria".

On project details Sheet "Maria" has 8 projects listed under her name and each project has a different start and end date from the rest. It should show each project name from the date it has started till it ends. If there are multiple projects falling on a same date than that cell must have the name for all those projects and since Sat's & Sun's are off they should remain black or Can have leave showing in it.

Now i am not sure if you need a macro or a formula is sufficient to do the job

Please advise.

Thank You!! in advance