Calculate how many items are between two dates

Hi community,

Hope someone can help me with this. I cannot seem to get the right formula.

I have two tables:

- 1st tabel contains a column with a datetime (creationDate) and a column with a locationname (name)

- 2nd table contains two columns with a date time (startDate & endDate) and a column with a locationname (name)

I want to create a matrix where I show:

- Rows: Locations (from table 1)

- Columns: Month (the matrix is filtered by year, i.e. 2020)

- Values: Here I want to show how many rows from the 2nd table, from which the startDate & endDate are in that month of the Matrix.

For example if a record in table 2 had a startDate of 02-11-2019 and an endDate of 15-02-2020, it had to be counted in the maxtrix value for januari and febrari of 2020, but not for march 2020.

I hope I explained correctly, if not: Let me know!

I appreciate all the help you can give me.