Sum entries for different date ranges (months)

[chvizda]

Hi all
I have a dataset with inventory data for different time ranges.

Now I need to know how many devices were installed for every month since 2022-01, based on the install date and retired date.

like 

2022-01 = 5

2022-02 = 8

2022-03 = 9 

..

..

2025-08 = 141

Some of the devices were installed only for some month within the time. (device 153/device 145/...). They must be counted only for this months.

I have attached an example dataset

Do you have eventual an idea how to calculate this ? 

Many thanks in advance for your reply.

Steffen

[caltang · Accepted solution]

@chvizda like this?

[chvizda]

it works perfect

many thanks @caltang