This is where Power Pivot will be useful.
First: resize Table1. It doesn't need to include all rows.
Then use Power Query to add Created Date and Resolved Date fields (date only, excluding time) to this table. Name this query Incidents, and Load To Data Model:
Now in PowerPivot, create a Date table (Design > Calendars > Date Table > New), and create an active relationship to Incidents[Created Date], and an inactive relationship to Incidents[Resolved Date], on field Calendar[Date].
Then you can create DAX measures:
Now you can create your pivot table, using Calendar[DateHierarchy] in Rows, and [Incidents Created] and [Incidents Resolved] as measures.
See attachment for worked example.
Bookmarks