Forum Discussion
Count date overlaps
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
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.
Amazing thanks Hans!
Last question - if a Project title was empty in the data table, can the LET formula be modified to exclude data in that column when counting etc?
I attach an example of what I mean. I guess an IF condition or FILTER within the formula would achieve it but not 100%
- Superstar thank you!