I have a schedule of tasks within my department for multiple projects. I have a pretty good idea of when the projects start and duration for each.

I would like to have 2 different outputs:

1. Schedule of when the projects end
2. Schedule of all the projects that are concurrent

I have attached sample schedule with the two asks below.

I am pretty confident I can do this in something like LabView – would be easy actually. Unfortunately, I am limited in my current position to doing this in google sheets and I am not proficient enough to figure this out. I could try and write script for this but would like to see a formulaic solution if one exists

Any help would be highly appreciated

Sample Schedule