Forum Discussion
Solved
Count date overlaps
Hi experts. Hope you can help! I have a data set as follows: Store Project 1 Project 2 Project 3 Project 4 Start End Sta...
See the attached version
HansVogelaar Thanks for your quick response. See attached. I hope it makes sense.
I am trying to get a number of projects "live" in each given week as you will see in the example.
My example works for the starting week, but I want the formula to check between the date ranges so that every week shows the total number of projects active/live
I'll look at it tomorrow (Friday)