Is this something like you had in mind?
This formula in H2 to return the earliest date. Then the first of each following month in H3 and filled down.
Then in I2 filled across and down to get the counts.
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
1 |
History ID |
Project ID |
Record Name |
Stage |
Date |
|
|
|
Prospect |
Opportunity |
2 |
1 |
1 |
Alpha Project |
Prospect |
5/20/2017 |
|
|
9/1/2016 |
1 |
0 |
3 |
2 |
1 |
Alpha Project |
Opportunity |
10/21/2017 |
|
|
10/1/2016 |
0 |
0 |
4 |
3 |
2 |
Beta Project |
Opportunity |
7/4/2017 |
|
|
11/1/2016 |
0 |
0 |
5 |
4 |
3 |
Gamma Project |
Prospect |
9/1/2016 |
|
|
12/1/2016 |
0 |
0 |
6 |
5 |
4 |
Delta Project |
Opportunity |
4/6/2017 |
|
|
1/1/2017 |
0 |
0 |
7 |
|
|
|
|
|
|
|
2/1/2017 |
0 |
0 |
8 |
|
|
|
|
|
|
|
3/1/2017 |
0 |
0 |
9 |
|
|
|
|
|
|
|
4/1/2017 |
0 |
1 |
10 |
|
|
|
|
|
|
|
5/1/2017 |
1 |
0 |
11 |
|
|
|
|
|
|
|
6/1/2017 |
0 |
0 |
12 |
|
|
|
|
|
|
|
7/1/2017 |
0 |
1 |
13 |
|
|
|
|
|
|
|
8/1/2017 |
0 |
0 |
14 |
|
|
|
|
|
|
|
9/1/2017 |
0 |
0 |
15 |
|
|
|
|
|
|
|
10/1/2017 |
0 |
1 |
16 |
|
|
|
|
|
|
|
11/1/2017 |
0 |
0 |
17 |
|
|
|
|
|
|
|
12/1/2017 |
0 |
0 |
18 |
|
|
|
|
|
|
|
1/1/2018 |
0 |
0 |
19 |
|
|
|
|
|
|
|
2/1/2018 |
0 |
0 |
Bookmarks