Forum Discussion
Count of Active Projects between two dates
My apologies if this exists already, i have been searching and found similar, but nothing that has worked when tested out, nor seems to fit this need. I have a table with a Project ID, Start Date...
Ashish_Mathur
Super User
Super UserHi,
Share some data that i can work with. I should be able to paste that data in an Excel file. If possible, please also show the expected result.
Its a simple table, Project list with Start and finish dates. Two Finish dates remain open because those projects are still active.
| Project | Start Date | Finish Date |
| Project 1 | 1/1/2018 | 5/7/2018 |
| Project 2 | 2/8/2018 | |
| Project 3 | 5/5/2018 | 8/20/2018 |
| Project 4 | 8/23/2018 | 8/24/2018 |
| Project 5 | 6/5/2018 | |
| Project 6 | 7/2/2018 | 8/10/2018 |
| Project 7 | 7/4/2018 | 8/9/2018 |
As i'm new to this, Its hard for me to show what the intended result should be visually... using a date slicer (slider) i would like to be able to change the dates, and have a card visual show the count of projects that were Active between the dates of the Slider. So if the dates of the Slicer are 8/20/18 and 8/23/18, it should show a count of "4".
Hope this helps illustrate better