Counting active projects by quarter
I need to count the number of projects that are active in each quarter by business area. I have a start and finish date. The will run over multiple quarters.
I have used this formula but this seems to only pick up what is active in this date bracket but does not include the projects that for example run from 12/1/19 - 06/06/20
Help Article Resources
Check out the Formula Handbook template!