I have a database with projects. Each project has a starting date and an end date. I would like to know for every month of the coming 2 years how many projects are active that month.
The only method I could come up with is to manually add a formula column for each month to my project database and use a formula to see if the project is active that month. However, this solutions scales badly if I want to use the information in other databases.
For instance, If I would like to use that information in my database with people to see how many active projects they have each month, I would then need to create these additional columns also in my people database. The same holds for my teams database etc.
Is there a better way?