Forum Discussion
Count date overlaps
See the attached version
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
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
See the attached version
Is it possible in your formula provided to include a condition ie. If one column is equal to?
For example if I added a column B titled "region". This could be Region A or Region B.
Therefore the resulting table only includes stores from the selected region (based in another cell)
See the attached example.
- Superstar thank you!
I'll look at it tomorrow (Friday)