CuriousBritt
New Member
- Joined
- May 17, 2017
- Messages
- 1
I have a list of projects that have a start and end date in an excel file. I want to find out how many projects were live for each month.
For Example, here is some data:
Project 1 started 11/1/2014 and ended 10/31/2015.
Project 2 started 12/1/2014 and ended 3/30/2015.
From that data, I need a formula to be able to find the live projects for each month. Below is what I would like to accomplish:
Live Projects for November 2014: 1
Live Projects for December 2014: 2
......
Live Projects for March 2015: 2
Live Projects for April 2015: 1
I've tried Countifs("start date", ">"&monthstartdatecell, "end date", "<"&monthenddatecell) but that doesn't work
<tbody>
</tbody>
For Example, here is some data:
Project 1 started 11/1/2014 and ended 10/31/2015.
Project 2 started 12/1/2014 and ended 3/30/2015.
From that data, I need a formula to be able to find the live projects for each month. Below is what I would like to accomplish:
Live Projects for November 2014: 1
Live Projects for December 2014: 2
......
Live Projects for March 2015: 2
Live Projects for April 2015: 1
I've tried Countifs("start date", ">"&monthstartdatecell, "end date", "<"&monthenddatecell) but that doesn't work
Project 1 | 11/1/2014 | 10/31/2015 |
Project 2 | 12/1/2015 | 3/30/2015 |
Project 3 | 10/28/2014 | 6/5/2015 |
Project 4 | 3/5/2014 | 10/5/2014 |
Project 5 | 1/15/2014 | 1/15/2015 |
<tbody>
</tbody>