Plot stock level of workload

[Back2Basics]

Hi

I have a table with 'Date received' and 'End Date' columns.

An item is 'Active' when there is a date received but no end date. Once an end date has been entered it si no longer active.

What I would like to do is plot a graph to show how many active rows there are over time. So the data would look something like this:

Date Received	End Date
01/04/2017	01/05/2017
01/04/2017	01/06/2017
01/04/2017
01/04/2017	01/06/2017
04/04/2017	01/05/2017
04/04/2017	01/08/2017
04/04/2017
01/05/2017
01/05/2017
01/05/2017	01/08/2017
01/05/2017	01/10/2017

Month	Count of Active
Apr	11
May	9
Jun	7
Jul	7
Aug	5
Sep	5
Oct	4

I can do this fr the current place in time, but I am struggling to make it work to plot a graph or to find the stock levels on any given date.